Viewing 15 topics - 265,786 through 265,800 (of 269,204 total)
Hi, how can I mail the result of a SQLServer 7 backup to an SMTP address ?
The result is written to…
17 years, 6 months ago
I have a simple delete procedure like this:
FROM tSchedule s INNER JOIN tSchDoneTemp d ON …
By: K. Brian Kelley
I just noticed the result set in query analyzer shows first rows returned if I am viewing in text f…
Ok, I am using 2000 and trying to find the debugger (I have never used it) where is it? The help f…
MY CPU is maxed out. Is there anything I can do besides add more and bigger processeors?
High CPU w…
By: Andy Warren
My 6.5 skills are a little rusty.
I'm a database programmer / analyst and I need to get the DDL for…
I want to duplicate some rows in a table and change the primary id field on the new rows. In affec…
Has anyone installed the .net framework on a sql server 2000 box runing win2k?
If so what are the i…
... I am trying to run an update on a field that will change a record status to 'live' if a record …
Upgrading a production SQL 7 (SP2) box to SP4. (No problems with the test upgrade)
Rebooted the ser…
In: Service Packs
I try to import a text file into a SQL 7 database via a linked server (Jet 4.0). I use a sim…
By: Johan Rastenberger
I need to performe a restore to a database everyday 2:00 in the morning which I made a job. sometim…
I tried to restore a new version of the database to my server and get the following error message:
Is there a way in sql server 2000 to determine if a user is part of an nt group that is defined in …
I know that there is a way to drop a user from one database but not from another. Does sp_drop user…