again, your timing is off: if you stop the SQl server service, you will see something like this in the events log:

17148 :SQL Server is terminating due to 'stop'...

turning statistics off is only good if you have a job to update the statistics manually. if statistics go out of date, execution plans can become outdated and have the...

I think your logic is backwards.... if the sql server is going down or, is already down/offline, you wouldn't be able to backup the databases...well...because the server must be up...

obviously there is an implied order somewhere, otherwise you would not want them in 3,1,2 order...is there a datetime field, or the order of insert (based on an identity field?)...

an FYI that you already know most likely: programatically automating excel is slow, and it is notoriously difficult to close the last excel object...so if you run task manager, it...

here's an example to show all records based on the criteria you described

SELECT SOMETABLE.* FROM SOMETABLE

INNER JOIN

(

SELECT F1,F2,F3,F4,F5,F6,F7 FROM SOMETABLE

GROUP BY F1,F2,F3,F4,F5,F6,F7

HAVING COUNT(F1) > 1 --FINDS ALL RECORDS WITH...

same here...in my case, developers were dropping and recreating databases all the time, just needed to be aware of it really; so i had to save the previous data and...

spot on analysis of some of the detriments of Oracle vs SQL Server...my shop has to support both as well.

we often copy the same identical database to SQL and Oracle...

creepy...looked in BOL for the CREATE database example, and their database is named Sales, just like you are asking:

CREATE DATABASE Sales

ON

( NAME = Sales_dat,

   FILENAME = 'c:\program files\microsoft sql...

you can also save a copy of sysdatabases to a table, and schedule a job to compare that table to the current sysdatabases to compare changes....same thing at the database...

I've always been interested in getting and programming a robot arm, but anything in the sub $500 price range are cheap, rinky dinky, have a lift limit of like 6...

wouldn't this query return all duplicates:

SELECT Acct_Num_CH  from TrxDetailCard

WHERE (Date_DT >= cast( convert( char(10), getdate(), 121 ) as datetime )) 

group by Acct_Num_CH

having count(Acct_Num_CH) >1

with that, i think...

in my case, I have a search function that does the top 50 similar to what you were asking for///however when i need the next 50, i make sure the...

most likely true now that i re-read the question; like almost of your posts, I try to give a solid working answer on a question, when it is worthy...but i...

i have this procedure which is designed to handle FTP to a site, with some minimal validation as to whether it sent or not...hope this helps: you'd want to expand...