There was a issue with sql 2005 but its being corrected in the subsequent service pack release.... dont remember which service pack though.

Which version are u using and what is...

Rbarryyoung is right there.

If you have a lot of database activity that causes loggin going then it makes sense to move the log file to a separate disk. Other...

Hi

What does the function do?

Hi

I think you should concatenate the date and time since there can be cases where the time interval is more than one day.

check out the convert function in BOL.

check this

http://support.microsoft.com/kb/933945

Hi

you cannot "backup" some tables. what you can do is import the data of the tables you want to backup to another set of tables.

select * From test where val like '%[%]%'

Can you make the question clear ?

Hi

Is your query using the clustered index?

Does your query have a where clause? If it does and you partition your data according to the condition in the where clause AND...

Hi

question is rather poorly worded. I thought the question was whether running the statements repeatedly would produce different results.

Hi

I think the issue might be related to parameterization. When u use variables, those variables can have many different values each time you execute the query. So SQL makes the...

Likely there is a trigger. But how are u inserting the row , thru SSMS, procedeure ?

Hi

what is the error that u got. did u check the error logs for the error details ?

glad i cud help...

Thanks once again Gail. Just goes to show that regular maintenance can reduce a lot of headaches...:)