Hello Sanjeev,

Are you trying to restore a SQL 2005 database backup to SQL 2000 server?

If so, it is not possible to restore a higher version database backup to a lower...

Hello Ali,

You can create a log file for the DTS package and then execute the package, so that it logs all the information and you can track of the relevant...

Hello Vic,

Can you remove "*" from your delete statement and then try it. Also check whether the table is having any relationship with a parent table.

Hope this helps you.

Thanks

Hi Jon,

I think you can change the owner of the "model" database like this:

1. Click on "model" database properties

2. Select the page "Files"

3. In "Owner", click on elipses (...) and...

Hello John,

It seems that the login with which you are trying to bulk insert the data, is not having enough permissions on the network / remote path.

Operating System Error Code...

Hello,

Trace flags, after they are enabled, remain enabled in the server until disabled by executing a DBCC TRACEOFF statement.

To determine the status of trace flags, use DBCC TRACESTATUS. To disable...

Hello,

I'm able to query the system table through the query provided by you.

SELECT sid, name, xstatus, password

Hello,

In order to bring all the DTS related jobs under the new service account, you need to log into the box with the specified new service account, then open the existing...

Hello,

These files will be created by SQL Profiler. Please check "Process Info" under Current Activity and you might find a process dedicated for collecting audit trace information.

Hope this helps.

Thanks

Hell John,

Have you checked the compatibility level of the database? 

Thanks

Hello Utsab,

You can save the DTS package as a file. Open the particular DTS package and in the DTS designer, click on Package -> Save As

Now you will be prompted...

Hello,

You can't select the data from a named instance like "servername\instance". You need to create / have linked server, so that you can use like

select yourcolumnname from linkedserver.dbo.databasename.table1

Look for Books...

Hello,

First things first,

1. Have you configured a mail profile with the domain account that the SQL Services are getting started?

2. Have you tested to send a test mail from T-SQL?

The...

Hello,

You can do it like this

Decare @yourtable table

(colname datatype,

colname2 datatype)

insert into @yourtable select col1, col2 from yoursecondtable where condition

select * from @yourtable

Hope this helps.

Thanks

Hello,

You can restore the database with an alternate name to it and direct the specific data and log files to a different drive, if you have any. Then you can compare...