You can install and use SQL 2000 on Windows 2008, however, it is not recommended and some features does not work as straight as on Windows 2000/2003. Read the following...

Are you getting error while inserting record from application or database itself.

In case of deadlock, you should see deadlock victim error message in database. Probably it could be some other...

You may follow the script similar to below for each column.

UPDATE TEST_DAY

SET IDATE=DATEADD(DD,1,IDATE)

WHERE datename(DW,idate)='sunday'

UPDATE TEST_DAY

SET IDATE=DATEADD(DD,2,IDATE)

WHERE datename(DW,idate)='saturday'

If nothing works from all the suggestion, then you need to verify that the sql server account should have write access to the network share.

Thanks

I know two ways of doing this, 1: Using MAPI Profiler (requires OUTLOOK) and 2: Required SMTP configuration. Here it is:

Method 1: The most easiest way of doing this...

Basically this is Excel feature that it puts a single quotation mark before any thing that seems to be anonymous data type to Excel. Single quotation mark tell excel that...

Always there is a reason for blocking. The blocking happens for the time when the process is active and runnable. You need to point out why the process is runnable...

I can share with you a small overview of blockings in sql 2000. Blocking happens when an object is being locked by a process (say process 100) and before the...

I am not sure if you are on the same boat where I was some time back. I had similar kind of issue, later I discovered that model database had...

Thanks. Sounds good.

There might be couple of reasons of database being in suspect mode. Check that the log files and data files have enough space to grow, if space is less, make...

You may try steps from the following link.

http://geekswithblogs.net/TimH/archive/2005/08/09/49716.aspx

I have installed all of the versions i.e. sql 2000, 2008 express, 2008 standard and enterprise on my testing machine, I do not see any problems. You just need to...

There are couple of ways of doing this..

However, the easiest way will be to select the list from backupset table in msdb db ....

select * from msdb..backupset

where type =...

It seems a cursor (even a While loop) will help you code the logic you need.