I think the only true way to find all is to scan every machine on your network checking for SQL server, only those setup in WINS, The same domain as...

EXEC xp_cmdshell 'net time /domain:xxxx /set /y'

SELECT getdate()

EXEC xp_cmdshell 'time'

Steve what version of SQL did you test on along with SP.

That holds true on my SQL 2000 servers, but on...

You have to get it to run successfully once. To run it right click the job and select start job. If completes successfully, then you can refresh the job and...

Good to hear.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Not really, that is just there statement based on number of posts. Truth is I just discovered that myself a little more than a week ago and I have been...

BCP can insert it, which it also allows you to set a /e errorcount which if you set to 40000 will ignore all errors since you file is smaller. However...

Sorry, I will get to this tonight, my wife stole my keyboard so I was without yesturday.

"Don't roll your eyes at me. I will tape them in place." (Teacher on...

Ok since we have a backup (we do have abackup of the files right) Try using sp_resetstatus DBNAME.

Note see BOL for more information, here is just...

You can use profiler to watch the process, if you are using SQL 2000 there is a debugger, look at BOL in the index for "Transact-SQL Debugger window" for help....

Oh it works and worked just fine under Oracle 7.x, but as the newer versions of Oracle came out (8.x, 9.x) I started having troubles with the Oracle Drivers and...

Just to offer another possible solution. Is this column searched in a large number of queries, if not have you considered using a computed column on the table as opposed...

I would also say that you have to make your opportunities sometimes. For example the way I got in was thru Access and lerning, but when the Y2K rollover was...

Let us know what happens.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Odd, never noticed, just checked and it takes just over a minute to resync. Based on BOL this should be the OS's system time. Apparently there is an internal clock...

38 is the average load space SQL takes up, what happens is as queries run it starts caching data and plans so that subsequent runs can take advantage of previous...