There are some limitations in executing DTS packages in SQL Server 2008.

The following link from msdn is worth reading.

http://msdn.microsoft.com/en-us/library/bb500440.aspx

Thanks.

Hi,

You can use a square brackets [] like -S[GCC0501921\SQLSERVER2008] to specify the server name.

This is a good practice.

DECLARE @cmd varchar(1000), @result int

SET @cmd = 'BCP BIW.dbo.BIW_Stage_Dim_DatabaseServer IN E:\temp\BIW_Stage_Dim_DatabaseServer.txt -N...

Hi,

Please check the below link.

This should work.

http://social.msdn.microsoft.com/forums/en-US/sqldataaccess/thread/c84ae5d6-7be4-4238-be8a-9982f6aa4c2c/

Thanks.

Hi,

The application connection string will contain the initial partner name and the failover partner name provided.

This helps to identify the failover server if the initial server is not reachable.

Below is...

Please read the following link.

http://msdn.microsoft.com/en-us/library/ms143215(SQL.90).aspx

If the above one does not solve the issue, then read the below one.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=356308&SiteID=1

Thanks,

Lakshmi

Great!

Your master database contains metadata about the entire server like the list of databases, list of logins etc.

This database gets regularly updates based on the server activities.

Your msdb database contains...

Hi,

Here is a Macro for excel to carriage return or linefeed characters.

Sub KillCR()

Dim ws As Worksheet

For Each ws...

Hi Chandana,

Can you try to create a simple package with just a Execute SQL task and run it from a job and see if this gives an issue.

Can you...

If your mirroring is configured for high safety mode safety = full with witness server configured, and if your mirror fails you should not remove the connection between witness server...

Please check the below site. It might help you as this error is generic and can be for different reasons at different scenarios.

http://social.msdn.microsoft.com/Forums/en/sqldatabasemirroring/thread/dd4bc7cf-32da-44ec-9850-b1a70d7a4123

Thanks,

Lakshmi

I am assuming that you are speaking about SQL Server 2008. Can you tell me if it is the primary filegroup or the secondary filegroup that you are talking about.

Thanks.

This one should help you.

http://msdn.microsoft.com/en-us/library/ms188283.aspx

Thanks.

In SQL Server 2005, Local Administrator group on the local machines would get access to SQL Server through the BuiltinAdministrators group that gets added to the SQL Server 2005.

But in...

Hi,

Your answer is available at the below website.

http://msdn.microsoft.com/en-us/library/bb500440.aspx

Thanks.

Hi,

1. A transactional two way replication can be initiated by running the snapshot agent, but a peer-to-peer replication cannot be done so. A backup of the publisher DB must be...