Hello,

Yes you can have/install both on the same server. As you are saying that you already have SQL 2000 - is it a default instance? if so, you need to...

Hello Suresh,

You can make your IF statement look like

IF Exists (Select name from tempdb..sysobjects where name like '#temp1%')

Check the select statement before incorporating it in the IF statement, so that...

Hello Nitin,

Can you check up whether the user who is running the backup command is having an exclusive access rights to the network shared folder?

Hope this helps.

Thanks

Hello Mark,

You will be loosing the support from Microsoft, if you try to change any of the system catalogs.

Thanks

Hello Michael

It seems you forgot to give the necessary output parameter in the statement.

Go through this link and you will find examples:

http://msdn2.microsoft.com/en-us/library/ms180944.aspx

Hope this helps.

Thanks

Hello Anandan,

Can you find any check box below after you select the databases in the Database Maintenance Plan?

Ship the transaction logs to other SQL Servers (log shipping)

Thanks

Hello Nick,

Do you want the equivalent data types to SQL 2000? If so, you can check in BOL this topic

data types-SQL Server, overview

Hello Deepti,

It might be due to a permission issue. Are you creating any file on the remote location?

The DTS package owner is not having the relevant access to the network...

Hello Andrew,

It would be better if you can schedule the steps for zipping the file and then mail the file to the user in a stored proc and execute this...

Hello Mahesh,

Do you require the earlier processed data? If so, you can go ahead with renaming the table created by adding the date to it before creating the actual table...

Hi,

You can go ahead with the detach - attach process. Check Books Online for detailed help.

Thanks

Hi Mark,

Who said that it is not supported in SQL 2005??

Check the SQL 2005 help.

Thanks

Hello Graham,

Whenever SQL Server is installed, it first checks whether there is any default instance available on the server. If so, it will prompt the user whether to upgrade it...

Hello,

You can query the system tables

sysjobs, sysjobsteps tables by having a join.

Hope this helps.

Hello Jones,

I too tried by mirroring the databases without a witness server. It is not allowing me to do the manual failover either from the Principal or Mirror sites when...