Have a look at this, may help a bit!

Create Procedure Test(@fname varchar(100)=NULL,

...

Observed a similar loss of a database a few months ago and as suggested a recovery service was able to recovery. Did observe loss of humor from management aswell.

Antares686 how do you structure your code with spaces or tabs.

My formatting always seems to get lost!

Antares686 how do you structure your code with spaces or tabs.

My formatting always seems to get lost!

Hanslindgren, what if default dateformat on server is 'yyyy-dd-mm'? Most unlikely scenario!

Suppose an Italian setting client connecting to a German SQL Server will also run into trouble where the three...

A while ago played around by creating a view like "create view select getdate()" and then access it from the udf.

House keeping, updating of system tables in master! Hopefully someone else can shed a bit more light on details what MS SQL Server does internally / behind the scene...

"Essentially I want to GROUP the data by column 1 and remove those records having "count(c1)> 1"

Question : What is the sequencing criteria or is it just a heap. I...

Don't think so!

One monster machine will make the DBA more invaluable to the company!

Can you explain in a bit more detail the part 'If I am able to attach a database that was not officially detached,'?

Any change to get the producer of the data to write it consistently as with a h, a m and a s.

Example: 0h 5m 0s or 0h 0m 2s

Any change...

Agree with Allen_Cui.

Otherwise if you insist you'll have go the 'xp_cmd / osql' route.

Do no think its worth even considering under normal situations.

Create Function Get_Numeric (@InField Varchar(2000)) Returns Varchar(1000) AS

Begin

Declare @Answ Varchar(1000),

...

Try xp_fileexist.

Assumes with a parameter like 'c:\.' one can check for a directory.