Viewing 15 topics - 269,941 through 269,955 (of 283,890 total)
Topics
Started by
Posts
Last post
My DBA team just discovered that as long as developers have EM loaded to their desktops they can st…
1 replies
Hello, I have a Stored Procedure set up to take a single parameter which represents a numeric ident…
2 replies
We have a small group of users (4) that use MS Access 2000 to run queries on our MS SQL 2000 SP3 se…
6 replies
I am trying to run a stored procedure that sends the results through the sp_sendmail stored procedu…
1 replies
Hi all, As you know, the following statement assigns QUESTID to @myID. 1. select @myID = QUESTID fr…
4 replies
I have a problem with a join of 3 tables. The tables are described below Master (table name) alias …
4 replies
Hello, I have a fairly simple SP set up to accept a single parameter value, but I need a default va…
8 replies
If you have a SELECT stmt with a DISTINCT keyword, are the combination of all columns referenced di…
2 replies
Using SQL Server 2000, the documentation says (that's for the XOR but same goes for the AND, OR and…
2 replies
Named Pipes or TCP/IP Sockets used for client to connect to SQL Server in local area network envir…
13 replies
When I run sp_who2, the disk I/O value is 157369 for msde. Does it mean the Disk I/O is high? How t…
4 replies
Hello everyone, I have a process that sends me the results of a query using xp_sendmail. However, w…
5 replies
I’m having problems understanding the relationship between checkpoints, buffer cache, dirty pages a…
7 replies
Question: what is the 'N' for in the where clause for this query? SELECT CustomerID, CompanyName, C…
8 replies
When running sql output to a file, SQL server likes to tack on 2 extra blank lines at the end with …
3 replies
Viewing 15 topics - 269,941 through 269,955 (of 283,890 total)