but the condition is given in code, not the actual condition

how do i get the actual condition?

Thanks dude

got the solution

just named the folders with the current date and use rmdir command

thanks sayfriend

any idea how to do the same thing with sql 2000?

thanks for the help eveyone

So what would be the ideal way to give permissions to developers. i want them to execute stored procedures, maybe create stored procedures (not drop them) also but make no...

I added the user to db_datareader and gave him execute rights on specified sp......... seems to be working

Thanks for the help SQL_Quest

Thanks Greg,

I read somewhere that opening SQL 7 dts packages in SQL 2000 designer can cause the packages to become corrupt.

any idea if this tool (DTSBackup2000) will transfer my packages...

Thanks Simon,

One more question, if i use the xml file generated using the above query and isnul function to insert data into a table will the null values in the...

I restarted the server and didnt get the error for the whole day today, maybe there is some issue with sql 2000 and windows 2003 server hard disk I/O we...

To be more clear the first table is

Column1 Column2 ...