you can check this Article http://www.sqlteam.com/item.asp?ItemID=8747 .

this will work great if you are using Sql 2k.

i would recommend you to convert the data in ISO format . Being a international standard it will always give you consistency.

CONVERT(char(10), ExpirationDtm, 112) .

i for one always store...

the code Klas gave might work .but am not too sure , how it will delete in the required order . coz, if any references do occur . this will...

Go to Enterprise Manager ,Right

Click on database ,All Task->Generate Script.

HTH

you can try something like this. i have used this Article. to write this. i have written it originally for space as a delimiter. feel free to modify it for...

sp_msforeachtable 'drop table ?'

will do it , but am curious why are you doing this.

you can use DTS to move your database directly from 6.5 to 2k.

AFAIK if your count is based on criteria , its better you directly query your table . but remember instead of using count(*) better use somethign like count(1) . i...

IMHO,its better you to store the image file seperately from the db and store its path in a varchar field and work your way with some deligent coding.

Just came...

my first question would be , is your SA password is blank? . if so,therez a virus on the prowl

If not a Intrusion detection system might help. Check out for...

Check this Article ,you can do it in Sql server too http://www.sqlteam.com/item.asp?ItemID=2955 .

i would suggest you to make joins by using join and on keyword instead of where coz AFAIK when you use where first a cartesian product is made and...

Try rebuildm.exe utility . this should help you restore your master db.

i would suggest you to check "startup options" in BOL.

Check to see if your system has any schedule jobs in the time you specified which truncates your data.

you should also follow Antares suggestion and have a look at profiler...

Thanx Antares, i was carefull coz the site am refferign to also has forums and am a regular there.

Anywayz, herez the link http://www.sqlteam.com/item.asp?ItemID=8747 .

Alternatively if...