If you're sure...

I'd go with John's advice to create an empty database (you may want to script your tables for future use)

Anyways, you'll need to begin with deleting dependent objects before deleting...

there are few articles on this web-site on how to insert test records.

eg..

http://www.sqlservercentral.com/articles/scripting/64884/

francis (2/15/2009)

---

Could anyone tell me that the procedure to follow for a backup transfer from Server01 to Server02 ? Cause I have a situation like this and the application...

mike (2/11/2009)

---

I'm looking for a tsql query to list the backups performed. Since I can see that info in the database properties I'm guessing there is a view or...

I guess this is what you require.

http://www.mssqltips.com/tip.asp?tip=1618

what is the recovery interval set for the database?

quoting from http://msdn.microsoft.com/en-us/library/aa174542(SQL.80).aspx

SQL Server 2000 always generates automatic checkpoints. The interval between automatic checkpoints is based on the number of records...

Adi Cohn (1/22/2009)

---

Backup log MyDB to disk =

'c:\MyDB$(ESCAPE_SQUOTE(STRTDT))_$(ESCAPE_SQUOTE(STRTTM)).trn'

This will create a file that is called MyDB_YYYYMMDD_HHMMSS.trn where instead of YYMMDD it will have the date and instead of HHMMSS...

xp_dirtree wasnt able to see files in the folder and after adding a dummy file, it showed all other files...

:smooooth:

I agree with Rio. From the application, copy the actual image to a folder and write this path into your table.

If you want to save the images to the table...

There must be some registry entries for this but i'm not aware.

You can check the creation date of the folders that were created during installation and manually calculate remaining days:hehe:

srawant (1/20/2009)

---

Hi guys,

My subject says it almost I have to mention. I need to drop all the users from all of the databases that does not have matching syslogins ,...

Tom Carnahan (1/20/2009)

---

I am doing some testing and need to detect the existence of a temporary (#) table that I created.

I tried the format you get when you generate...

Yes. Thats what i wrote. The first post in the thread says epool table is empty:)

yisaaacs (1/21/2009)

---

My query extracts the daily sales figures from production for the previous day and every morning at 9am a report is sent to management detailing everything that has happened...