26601:
Non-deterministic Clustered Index for Indexed View
26602:
Error 823: I/O error (torn page) detected during read at offset...
26603:
Error 823: I/O error (torn page) detected during read at offset...
26604:
Programatically View / Stored Procedure with N fields
26605:
Need help with Stored Procedure
26606:
Store Procedure check
26607:
SQL Server 2005 : Where are the Scripting Options
26608:
Need records forthe last month
26609:
unable to access dbs other than default dbs
26610:
Error 823: I/O error (torn page) detected during read at offset...
26611:
Cross Tab SELECT
26612:
General network error. Check your network documentation ADO.Net error
26613:
How can you mass-validate stored procedures, views, etc?
26614:
Making strings safe for SQL?
26615:
How to check if server address is valid?
26616:
Schema Sample For Financials
26617:
How do you reduce the size of the Log File when using SQL Server 8?
26618:
how to select distinct rows problem?
26619:
Null data source to default value
26620:
How to use LIKE in a store procedure
26621:
Login failed State 16 SQLServer 2005
26622:
SQL2005 and 4GB of RAM : How do I use it?
26623:
GROUPING problem
26624:
DTS Package Migration Wizard error
26625:
Right way to do a insert
26626:
problem with select * from [remote server] in QA
26627:
Trigger Security
26628:
Use UDF which returns a table in a join
26629:
Inserting data into a table which already has identity
26630:
Doing the lookup on the server while inserting
26631:
LoadFromSQLServer method has encountered OLE DB error code 0x80040E09 (EXECUTE permission denied on object 'sp_dts_getpackage',
26632:
Get Today's Records
26633:
How do I link tables to another database?
26634:
I am getting an error in creating a simple store procedure!
26635:
Quick Stupid Question, One to One Relationship Storage
26636:
BULK INSERT permissions for non-admin?
26637:
Top 5 Quesiton
26638:
Stumped on filtering data by date
26639:
Stumped on an Update Query
26640:
How to best handle multiple parameters?
26641:
Join using LIKE ?
26642:
BLOBs and Stored Procedures
26643:
Stored Procedure generating error
26644:
Complex View creation question
26645:
Calling Stored Procedure from asp without waiting
26646:
How-To create a "Dirty" Stored Procedure (Relates to Transaction)
26647:
Use float or decimal to get time?
26648:
Copy users between databases
26649:
Sub Query ?
26650:
Msg 226, Level 16, State 6, Line 4 ALTER DATABASE statement not allowed within multi-statement transaction.
26651:
Automating data exports
26652:
TSQL for date of next weekend
26653:
A stored-procedure becomes slow and needs re-creation
26654:
timeout error in calling from asp
26655:
Any way to query EXECUTE perms on stored procs?
26656:
How to allow normal user (not Administrator) deployment of SSAS Cube?
26657:
sp_sqlagent_notify problem
26658:
Multiple queries SQL
26659:
Interesting Query
26660:
security for row level but not based on Database user's login
26661:
select all the rows where min_date_time <= curr_time <= max_time.(How?)
26662:
Why does (SqlInt32)sqlCommand.ExecuteScalar(); : Throw Specified cast is not valid.
26663:
service broker management views
26664:
Suggestions for JOINs in audit tables.
26665:
OPENXML Insert into table failure not producing @@Error
26666:
pulling unique records from this query
26667:
Data Parse Challenge
26668:
OPENDATASOURCE
26669:
SqlPipe output from CLR sproc
26670:
How to insert empty string
26671:
function versus stored proc
26672:
Problem building query string
26673:
How to use EXEC
26674:
Import DBF File into SQL Server using vb.net
26675:
1434 problem
26676:
Oracle to SQL Server Migration
26677:
EXISTS Vs. NOT EXISTS
26678:
Finding special characters in field?
26679:
DTS ActiveX Script error
26680:
SQL2005 SP1
26681:
wscript.exe vs cscript
26682:
Table Design Question - Infinite Menu Level Items
26683:
Next question regarding to backup location.
26684:
Convert Access Query to Transact SQL 2000 IIF to CASE
26685:
TSQL statement Varchar/char to datetime
26686:
How to generate unique key? (ala Oracle sequence)
26687:
using OPENQUERY in stored procedures with parameters
26688:
UTC -> Local Time conversion - How to? (SQL Server 2000)
26689:
Variable suddenly getting undeclared
26690:
JIT Debugging
26691:
UTC -> Local Time conversion - How to?
26692:
Can I populate an existing table from inline function table data?
26693:
Reg-Gate's SQL Compare
26694:
Is there a better way of doing an INSERT or UPDATE
26695:
ADD IDENTITY PROPERTY WHEN THERE IS ALREADY DATA
26696:
Total by company
26697:
SQL Server Execution Time, elapsed time, Overstated in Query Analyzer
26698:
Can you help me to remember
26699:
Creating a Crosstab in SQL
26700:
schema design question
26701:
Recursion problem...
26702:
Question on MTS and SQL Server
26703:
Have you found any solution for this?
26704:
convert float to string
26705:
Regarding databases
26706:
Two EM at the same time..
26707:
Dts to SSIS...
26708:
Copy Database to another Database
26709:
SELECT with Exclude?
26710:
Profiler Trace Analysis
26711:
Performance between SP3 and SP4
26712:
Service Broker queues
26713:
Having condition
26714:
Service Broker queues
26715:
Table format change
26716:
Bitwise or aggregate function
26717:
Setting up foreign key
26718:
Question about CASE
26719:
Executing a command inside a read loop
26720:
size of a table in bytes
26721:
Search all Varchar fields in Database for text
26722:
Format numbers in a view
26723:
Converting text output of execution plans to graphical
26724:
at a time more than 8 users executing sp_xml_preparedocument what
26725:
Query in SP3a retreives result in different order in SP4
26726:
N Preceding Strings when Scripting Objects
26727:
diff between Cast and Convert
26728:
Locking Problem
26729:
Logging IP of connecting users
26730:
**longest text in SQL**
26731:
Algorithmic question
26732:
Max() on many columns performs slowly
26733:
sysperfinfo table empty
26734:
Processing tables with hierachical contents
26735:
While Inserting into a Table, it takes more than 10 secs...
26736:
shell object does not execute command.
26737:
Insert Primary Keys to all tables in a database
26738:
The usage of substring
26739:
How to extract the string
26740:
Handling error level 16
26741:
function vs stored proc
26742:
checking object usage
26743:
Update numeric value?
26744:
Arithmetic Overflow
26745:
How to access a UDT indexer (aka default property in VB)
26746:
need an alternative for this simple query
26747:
oreilly
26748:
Table Lock on a Simple Update .. Using PrimaryKey as the only value in the WHERE clause // The whole table locks
26749:
Controling xp_sendmail
26750:
INSERT INTO EXECUTE Holds EX_PAGE .. Still an Issue for 2000/2005 ???
26751:
Export Blob (images) to file (jpg)
26752:
possible to concatenate text to Where clause?
26753:
Scan and Write a varchar into numeric column
26754:
Create Procedure Error?
26755:
stored procedure rights
26756:
What's the best way to keep a live db and an archive db?
26757:
i can use SQL2005 Client Tools with SQL2000?
26758:
Reporting + SQL Server 2005 + assembly and "small" problem
26759:
How do I rebuild object dependencies in SQL2000?
26760:
User Defined Function Criteria/Default problem
26761:
Truncating DECIMAL data type
26762:
Is it possible to create CLR function call legacy C++ models?
26763:
How to USE <DatabaseName> in a stored proc
26764:
Temp Table
26765:
Concatenate Date & Time
26766:
how to specify default value of '%' for int param in SP?
26767:
How can I make this update statement faster
26768:
Improve Update Statement
26769:
Multiple row insert only inserting one row?
26770:
sql cookbook.
26771:
UNIQUEIDENTIFIER datatype
26772:
convert float to string
26773:
Using OPENQUERY
26774:
Whyis "Manage Indexes..." grayed out?
26775:
Retrieve GUID from SQL 2005 Stored Procedure
26776:
Calculation between rows in one field
26777:
problem with If Exist select
26778:
Dynamic From Clause
26779:
SSIS Result Set
26780:
Partitioned View performance
26781:
SQL View
26782:
Updating table without using cursor
26783:
Indexed Views are they supported?
26784:
SQL Server has lock on COM DLL
26785:
Recursively creating a String using Cursors
26786:
Is UPDATE worth the effort (in this case)?
26787:
semi-colon as a batch separator
26788:
Re: Daylite saving time problem
26789:
Efficient SQL Backup?
26790:
Stored Proc Parameters
26791:
What am I missing in this INSERT???
26792:
vb6 dll - called from asp classis - [SQL-DMO]Invalid parameter type;...
26793:
::Info Request::
26794:
Generate SQL Script using a DTS
26795:
DBCC fails, why?
26796:
xp_cmdshell
26797:
Importing a text file using Express
26798:
sql cookbook.
26799:
Kill a SQL process
26800:
Does SQLSERVER support fuzzy text searching(like the function of agrep).
26801:
Triggers not Updating
26802:
integer datatype confusion, signed vs unsigned
26803:
local and distributed transaction
26804:
What is the problem of using the IDENTITY column as the only key for table.
26805:
update column dependent on previous values
26806:
Temporal db design ?
26807:
Executing BCP from C# code
26808:
Protect my database (BE)
26809:
Daylite saving time problem
26810:
Insert 200 rows in one insert statement
26811:
How to insert ten rows in one insert statement
26812:
is there any limit to how long of a string SqlDataReader.GetString() can return?
26813:
CHARINDEX returns zero in TEXT column
26814:
How to get a previous rows result to currect rows for calculation
26815:
How to capture out param?
26816:
SQLDMO: Database SpaceAvailableInMB reports differently in SQL2005
26817:
Referencing another Database in a query
26818:
Will it be faster to use CLR UDF?
26819:
rtrim in sql server 2000
26820:
Appending to a Text field
26821:
How can I swap rows to columns in a SELECT statement
26822:
Joining 2 tables via 3rd table
26823:
Q280468 Bug/Error SELECT with GROUP BY ALL still occurs in 2000, 2005!
26824:
CLR UDF deploy failed
26825:
Put constraint on this
26826:
add words to FTS dictionary
26827:
Cannot get serverproperty
26828:
My convert vchar to numeric - why doesn't it work?
26829:
Select from Two Tables each Column that is Different
26830:
N - curious?
26831:
Oracle Performance Group Leverages Mercury Application Delivery Offerings
26832:
Any C++ TVR UDF example?
26833:
Query Parallelism (maxdop)
26834:
SQLDMO.dll Redistribution Best Practice
26835:
Bulk Insert from Memory (without using physical file)
26836:
Transact-SQL
26837:
data replication
26838:
C# UDF project call C++ model (SQL Server 2005)?
26839:
List tables used in a SP
26840:
Text data type support in trigger, SQL 2005
26841:
Auto-Increment
26842:
Scripting Primary Key creation with DTS
26843:
Connect to SQL Server over the internet
26844:
Error Handling in procs etc.
26845:
Native client and the UDL
26846:
Frequency of joins between two tables in a database.
26847:
CLR function performs worse than T-SQL
26848:
SP return status
26849:
Transactions
26850:
SQL 2005, ADODB & Print Statement behaviour
26851:
show which material was most ordered
26852:
looking for a T-SQL Parser for .NET
26853:
Add Images to table of SQL Server 2005
26854:
About Disconnected Record Sets
26855:
Structure M:M
26856:
SQL Server 2005, .Net / CLR Support and Event Handling
26857:
How to browse INFORMATION_SCHEMA in Enterprise Manager
26858:
Unable to create login instance--why? what it means?
26859:
Query HELP!!!!
26860:
Formatting Dates
26861:
Temporary table causes slow execution
26862:
index fill factor
26863:
How to Send a Windows Message from a Trigger?
26864:
KB article 246133
26865:
sql reporting services
26866:
Looping through sysDatabases to perform maintenance
26867:
select group/ max items
26868:
Info!!
26869:
Cast as Decimal
26870:
Concatenate All values to one select
26871:
XML Export
26872:
MSDTC on server <Server-Name> is unavailable.
26873:
SQL 2005 - transferring objects in ASP classic - vb6 dll - can I do this?
26874:
Invalid column name
26875:
unable to drop a sql server database
26876:
Trigger on main table to update itself with detail totals
26877:
Retrieving other table-column properties
26878:
DTS - Dynamic Property for txt file path...
26879:
returning row from function
26880:
Change NOT NULL to NULL?
26881:
add coll in specific order
26882:
Query Timeout Issue with .NET
26883:
insert * from the same table
26884:
VStudio 2005, SQL Server 2005 and CLR integration: How to do it within IDE?
26885:
Call Stored Procedure Within Stored Procedure!
26886:
Weird..
26887:
Add text to paramaterized query result in SQL Server -- is it possible?
26888:
query help pls
26889:
Timeout Expired on SQL 2000
26890:
Whoopsie Trigger
26891:
Bday dates revisited
26892:
Syntax error converting datetime from character string.
26893:
representing months with columns
26894:
When to use stored function Vs. stored procedure?
26895:
wrong result set
26896:
Condition in FROM vs WHERE
26897:
Performance problem
26898:
how to write a stored procedure that adds a record to a table and returns the value of the ID Column
26899:
Help: select DATEDIFF(day,date1,getDate())/DATEDIFF(day,date1,date2) as r_ratio from test;
26900:
See, THIS is why we give the views to the users
26901:
select * in views
26902:
DTS Append Records
26903:
Odd SQL Performance problem
26904:
Finding the break in sequence
26905:
connectivity
26906:
Exact Difference between SQL Server 2000 and SQL Server 2005
26907:
how to print output return by stored procedure
26908:
DateTime string insert into sql datetime column fails
26909:
DNS Hostnames
26910:
How to make KEYWORD uppercase?
26911:
Performing Calculations on Values in Different Rows
26912:
Finding illegal characters
26913:
using a variable in a LIKE statement
26914:
Microsoft, Cisco, Comptia, Oracle, Solaris -(Pay after check result) 100% Exam Pass Guaranteed
26915:
compare merge and insert
26916:
Code Level for Deadlock Detection
26917:
Query Notification & Windows Service
26918:
how to group by similar sounding Names/text?
26919:
Top
26920:
Storing and Updating DateTime Values
26921:
Cast Error
26922:
Tricky (to me!) SELECT problem - MSDE 2000 TSQL
26923:
Query Analyzer question
26924:
Horizontal data storage without partitioning - suggested approach
26925:
Urgent !! Trace pictures problem !!!
26926:
Execution Time is different
26927:
How to group by date
26928:
How to ensure the rest of the records will be inserted even if there is an error
26929:
text pointers
26930:
SQL Insert sataements for system date
26931:
How to increment a column with varchar data type
26932:
'Object Not Found' Message when executing Stored Procedure
26933:
linked server to oracle
26934:
[OT] Interesting Math Problem
26935:
How to split a field into two fields
26936:
Cannot sort a row which is greater than 8094??
26937:
Full Text Search Filters What is installed?
26938:
Getting Row Number in the Db
26939:
Pulling trans logs from one server to anthother
26940:
ASP.NET 2.0 Tree Control and Navigation Controls - General Question
26941:
Upgrading MSDE 2000 to SQL Express 2005
26942:
How many joins is too many?
26943:
CASE in where clause?
26944:
select statement to assign values to multiple variables using min()
26945:
Can I register SQL 2005 Server in the SQL 2000 Enterprise Manager?
26946:
Convert varchar to decimal
26947:
can view be dynamically filtered like an MSAccess query?
26948:
most efficient way to check for table?
26949:
Want to buy Pentium 3
26950:
Stored procedure not returning a resultset