23801:
Global Function in 2005
23802:
Update statement for linked server
23803:
Count results in colums instead of rows
23804:
Help with error 3274
23805:
about store proc
23806:
Parameter transfer over View on linked servers
23807:
Return Last 10 records
23808:
Help Me
23809:
Obtain MCSE,MCSD,MCSA,MCDBA,CCNA,CCNP without exams(Pay after check results)100% passing gaurantee
23810:
Need help design the database for the scheduling task
23811:
error converting nvarchar to int
23812:
Select date range with no minutes
23813:
error-checking all in one place
23814:
Need help on database design for serving delayed data
23815:
How to add same user to diff DBs on diff Servers?
23816:
Rather Simple Logic - Need some advice
23817:
SP NOT INSERTING BUT INCREASING @@IDENTITY
23818:
select top row from each group w/o using cursor - how?
23819:
How can I run sp_adduser in a trigger?
23820:
Email Validation in reporting Sevices...
23821:
Parameter is null, return all?
23822:
DMO Distribution Question
23823:
How to call a stored procedure from a function
23824:
IIF
23825:
SQL Optimization
23826:
Find similar items
23827:
transaction log full error - out of space - need help to troublesh
23828:
Variable appending
23829:
Cannot create trigger 'dbo.Profile.ProfileCodes_AspNet_SqlCacheNotification_Trigger' as its schema is different from the schema of the target table or view.
23830:
command scripts
23831:
Need Help on update trigger
23832:
Recordset Find method vs. direct SELECT SQL statement - which is better performance-wise?
23833:
SQL99 Question : Why No Boolean Value Columns
23834:
average question
23835:
Query - perhaps GROUP BY
23836:
error-checking on INSERT
23837:
RE: bulk insert on remote computer
23838:
Trying to improve Stored Procedure
23839:
Change Notification needed in .NET
23840:
Same query...???
23841:
Transaction option
23842:
SQL query against data on tape...
23843:
isolation level
23844:
Using ranges in between operator ?
23845:
Joining three Tables in Sql Server
23846:
need a date look here
23847:
'ROW_NUMBER' is not a recognized function name.
23848:
ss2k : maxdop matters with 1 cpu ... huh ?
23849:
Stored Procedure
23850:
Select All Columns in Pivot Table
23851:
TSQL INNER JOIN BETWEEN TWO DATABASES
23852:
Unicode text into my database
23853:
xp_cmdshell in SQL 2005
23854:
Index Tuning Wizard is giving error message
23855:
Replication - Replicating the contents from a view to a Table
23856:
Max() across 2 tables in one query?
23857:
SSIS Problem
23858:
permissions needed for trigger
23859:
TRIGGERS and LINKEDSERVER
23860:
Update Query Locks-up
23861:
New Import/Export Wizard error
23862:
Multiple DECLARE Sections ... why?
23863:
Storing User ID and Salted Hash Password
23864:
OPENQUERY vs. sp_executesql which is better?
23865:
Datalist update function creates multiple instances of updated record
23866:
How to: Dynamic crosstab procedure without aggregate functions for text
23867:
operation on strings in a request
23868:
Changing the Recovery model of the database using scripts
23869:
UPDLOCK
23870:
For Loop help
23871:
Copying/ Deleting Huge Data from a table
23872:
store procdure question
23873:
how to get tablename in CLR-Trigger?
23874:
UDT in SQL 2005 and IDENTITY
23875:
DTS task
23876:
Cursor and dynamic slq
23877:
Update if Delete fails
23878:
Whty backup master ?
23879:
Autogenerate data
23880:
Cross Referencing The Same Table
23881:
SQL Server 2005 SMTP and POP3 - Suggested Reading Please...
23882:
literature for starting SQL users/ book to use SQL server as a backend for a MS Access frontend?
23883:
Problems Using a View of a View
23884:
Problems Using a View of a View
23885:
Line 1: Incorrect syntax near 're'.
23886:
BCP in using bcp_sendrow fails, not enough columns bound
23887:
trouble connecting to a SS2K instance from SEM
23888:
insert row question
23889:
Create Table In Store Procedure and inserting data with the Kalen user.
23890:
SQL inserts random CHAR(13) into stored procedures
23891:
Debug SProcs
23892:
how to get the parameters information of UDFs?
23893:
How to optimise job conflict
23894:
Stored Proc Doesn't Run in Shell Script, but gives no errors
23895:
Help with user defined function
23896:
Unpivot in T-SQL 2005
23897:
Get last inserted PK
23898:
Can this be changed to a CASE construct?
23899:
Selecting a row by row number
23900:
Concatenated string as parm value
23901:
[OT] User-Defined string Functions Transact-SQL
23902:
Line Feed in Text Box on rdl file
23903:
using variable with quotes - do I need to use QuoteName?
23904:
SQL Query HELP!!!
23905:
Linked Server VFP, error OLE DB
23906:
Please Help ... Can't Figure This One Out
23907:
Quotation marks
23908:
Need help with a query
23909:
Dummy Keyword in SQL Server
23910:
error handing and IGNORE_DUP_KEY
23911:
Query to Return Duplicate Number of Records Based on Value in Fiel
23912:
use column value subquery
23913:
Limiting Rows in a Report
23914:
Using Materialized Path to create a paths table
23915:
Store text files in a column ?
23916:
Previous row calculations using SQL
23917:
call database Maintenance plan from Sql Server Agent->Job
23918:
Nullable column in composite natural key
23919:
Working with both 2000 and 2005
23920:
Triggers?
23921:
Can we do the Validations in bcp format file
23922:
Can we specify the format of the date field in Format file
23923:
Row Correlated calculation Query
23924:
How to identify one sql server installation to another
23925:
FileIopermission
23926:
Equivalents For sysdatabases and syslogins?
23927:
Updating SSN column with incrementing numbers
23928:
Copy database from an Sql server to another
23929:
Converting negative numbers to positive
23930:
Assign a variable result to a global variable in a stored DTS
23931:
best/fastest why to do this - high level
23932:
OUTER JOIN issue
23933:
Deleting a login account
23934:
MS SQL Server 2000 - Run query as a different user
23935:
Permissions
23936:
For Each Loop Container in SSIS
23937:
Help with SQL query
23938:
View for accumulate data
23939:
Need help with poorly performing SPROC
23940:
Check for constraint on delete
23941:
watching a column value
23942:
trailing spaces in columns
23943:
Update integer value based on "group by" clause
23944:
Extract a character string from a text field
23945:
Statistics on each column
23946:
Need help inserting into row, not adding a row
23947:
Update table with stuff from another table?
23948:
Index of length xx exceeds the maximum length
23949:
Question on building Time Zone Tables, Daylight Savings Time Table
23950:
Help using COALESCE on field containing NULL
23951:
MCDBA Certification
23952:
Convert date format into May 24, 2006
23953:
bcp, empty strings and null
23954:
writting vb code to insert images and text into a table or retriev
23955:
Linked server
23956:
check if field contains numeric character
23957:
Can we call functions that assign a value to a field
23958:
sp_addextendedproperty
23959:
XML input; Have insert can't figure out updates.
23960:
parsing Vabinary contnt
23961:
How to access Webservice from SQL Server 2000
23962:
Scripting database, table, view and SP creation all in one
23963:
Post-Relational Databases
23964:
Best way to take backUp
23965:
Calculated Columns
23966:
How to manipulate column data to place in a temporary table
23967:
List of weeks
23968:
Index Tuning Wizard and Distributed Queries....
23969:
Shedule DB BackUp in SQL 2000
23970:
placing table on the memory
23971:
using cursors
23972:
Index Column Updation
23973:
Get the SQL Server Unique ID of the Server
23974:
what to do when identity overflowed
23975:
Help with Sql Statement Where Like Column Query
23976:
Using Transactions with Aliases
23977:
How to get the current User when using a general connection user
23978:
T-SQL to create a Wealth Index on the fly.
23979:
What is the optimal way to syncronize records between two tables?
23980:
stored procedures input values
23981:
How to access the result of the dynamic sql in sp
23982:
CLR SqlTrigger and Schemas
23983:
how to select a value into variable in sp
23984:
CmdExec issue
23985:
Deprecated features in 2005
23986:
Opinion on SQL Stored Procedure Syntax
23987:
Boolean bit field Which is True False
23988:
Importing data into a view
23989:
Creating a Trigger on Table Access
23990:
Number of columns in a query affects the number of rows returned?
23991:
Disable Macros on Save As
23992:
Having trouble implementing complicated business rules.
23993:
Run SSIS from ASP.net
23994:
nvarchar and output to flat file.
23995:
What does not get backed up?
23996:
IF ELSE problem in Complex T-SQL
23997:
BCP Queryout export to XML Question
23998:
order of "RAISERROR" and "ROLLBACK TRANSACTION" in trigger
23999:
insert into tbl1 select * from tbl2order by field1 doesnt work!
24000:
Tough Question!
24001:
output to file
24002:
how to return truncated field
24003:
SQL Qry question
24004:
How to change columns to rows
24005:
adding a counter to a select query?
24006:
distinct query
24007:
How to retrieve name of current database in TSQL query
24008:
CmdExec Jobs
24009:
.adp successor front-end to SQL Server 2005
24010:
problem creating view on table from linked server DB using IP addr
24011:
'Enforce Distributed Transactions'
24012:
Does It Matter...
24013:
Conver String to Date
24014:
Accessing variables inside a custom logprovider in SSIS
24015:
Slow SP - Is it an index problem
24016:
Create a New Database that doesn't resemble the model database
24017:
How to Dump Multiple Stored Procedures to Multiple Files?
24018:
USP returning wrong value. Help!!!
24019:
cursors problem
24020:
Joining across databases
24021:
a humdinger of a performance problem
24022:
Stored Procedure running VERY Slow
24023:
SQL 2005 MCTS, worth doing?
24024:
conventions about namereferences
24025:
Partitioned Table + File groups
24026:
How to launch a SSIS programatically from VB 6.0?
24027:
Size of some records
24028:
Best way to this?
24029:
INSERT WHERE
24030:
DTS package to import a csv file on a web server
24031:
loop through few table in sp
24032:
Getting Return Code from a stored procedure
24033:
Stored procedure not working same as direct select statement
24034:
fulltext query problem
24035:
Stored procedure with a parameter that accepts a list of values
24036:
Slow query!
24037:
BCP's /F switch
24038:
Update question
24039:
Syntax question - sproc table input parameter used in from clause
24040:
HELP with WHILE LOOPs in a CURSOR
24041:
Backup db to another computer?
24042:
Querying a stored procedure.
24043:
Devide by zero error
24044:
Matriz SQL
24045:
Get Value of Parameter whos name is in a variable
24046:
SUM function
24047:
SQL Server Exress and Management Studio annoyance
24048:
Going from an Insert to an Update
24049:
Restoring a database with horizontal partitioning onto a Standard
24050:
Optional Columns In Query!
24051:
create comma delimited select list from return values of select query
24052:
Universal log table using XML data type?
24053:
Exec Stored Proc (C#) - the Size property has an invalid size of 0
24054:
Is user allowed?
24055:
Programmatically finding all SQL Servers and their instances
24056:
Using T-SQL to copy a table
24057:
Table Size greater than DB size ?
24058:
ExecuteNonQuery requires an open and available Connection
24059:
ExecuteNonQuery requires an open and available Connection
24060:
grouping records
24061:
store procedure question
24062:
Best Real Datatype
24063:
Trigger Nesting level execeeded
24064:
Maximum job size limited to 3200 bytes
24065:
Newbie seeking some simple (?) split advice
24066:
Data Flow Task Destination UPDATE
24067:
Simple Model, Log File Growth
24068:
transfer from oracle not correct
24069:
How to show sp_cursorfetch in profiler
24070:
question about Trigger
24071:
BCP/DTS/cmdshell problem
24072:
Queries with "like" and full text indexes
24073:
SSIS generic List in CustomPropertyCollection
24074:
Dimension Tables
24075:
Upgrading DTS to SQL Server Integration Services
24076:
Execute Integration Package by SP
24077:
Optimize the query performance
24078:
Could Stored Procedure or Trigger choose another database on difference engine?
24079:
Statistical information on non-indexed columns, why?
24080:
help with an update
24081:
SQL 2005 performance and scalability
24082:
Select same column multiple times
24083:
Querying table from remote sql server
24084:
Option seaching criteria in sproc and it's performance
24085:
length of an image column
24086:
Maximum Exposure Lingerie
24087:
Where is ROWID in Sql Server 2005 like Oracle ?
24088:
WHERE clause
24089:
Count in Join
24090:
sql 101...
24091:
MSDE...
24092:
SQL 2005 : Caclulating a CompanyCode : Where should this be done?
24093:
What is the best way to do this in SQL 2005 ?
24094:
Problem with DTS
24095:
Is it possible to view queries run on sql server by particular user ?
24096:
Getting T-SQL to use LIKE, REPLACE, and IN... all at the same time???????????????????
24097:
SQLDMO: Registry->AutostartMail property - where in registry?
24098:
substring search in each row with a different wildcard
24099:
SQL local server db connection
24100:
to read backup file
24101:
Between clause...
24102:
xp_SendMail subject blank problem
24103:
**Update**
24104:
HW Requirement for SQL Server 2005
24105:
"Not enough Storage"
24106:
SP - drop table problem
24107:
performance questions
24108:
Slow Insert On Linked Server
24109:
Block to drop any object with ddl triger
24110:
Referential Integrity - Countries & States/Provinces
24111:
Hidden Master, Model, MSDB, and Tempdb Databases.
24112:
Production Server Down - help!!
24113:
how to supress instance name while logging to sql server 2005?
24114:
Slow Join On Linked Server
24115:
SMO not installed for SQL Server 2005
24116:
HELP! "could not complete cursor operation because the set options have changed since the cursor was declared"
24117:
Help With the CASe syntax
24118:
temporary view
24119:
How know when one Table was droped? HELP-ME
24120:
Problem selecting duplicate values.
24121:
need help with a query
24122:
FOR clause in mssql2k5.
24123:
Select strategy
24124:
use static tables or create tables at runtime?
24125:
understanding what trigger is doing
24126:
Use DISTINCT and still retrieve all columns
24127:
Triggers and bach insert
24128:
Help - Can Execute return a value?
24129:
Could not create an instance of OLE DB provider 'Microsoft.Jet.OLE
24130:
Is it possible to update two tables with a single statement?
24131:
Optimize the query performance
24132:
Delete 'Non-Unique' Rows Question (with DDL)
24133:
Nested IF statement and Declare problem
24134:
Is this index redundant?
24135:
Splitting name column into seperate columns
24136:
Quick Dumb Question
24137:
Moving Data Question
24138:
Using a CASE to Determine if a Column is included in the SELECT clause
24139:
Is there a correct syntax for writing a query?
24140:
Backup-only ID
24141:
Newbie question - Need count to return multiple values
24142:
Get active directory users from SQL Query Analyser
24143:
Problem with query
24144:
SQL Query Help
24145:
Different between ##table and #table regarding performance
24146:
Generating Nested XML Tree nodes in SQL Server 2000
24147:
Dynamic SQL Query
24148:
Problems while migrating from MSSQL 2000 to 2005 - select... into fails in a trigger - please help.
24149:
Applying aggregate function to whole table
24150:
Automatically reformat SQL Keywords to UPPER CASE