Thw written word is like SQL ... there are many ways to express the same function ... Thanks Yelena !

Have  Great Weekend !

P.S. My weather is supposed to be sunny and...

Sushila, if you reread the MS press elease article more carefully you'll digest the fact that this 'transition' in MS has been occurring for some time now (the last few...

The lack of response to this topic is refreshing. It manages to restore the faith I hold in my fellow technology workers. Bill is retiring in 2 years ... BFD ......

You should not have to do something 'special' if the target computer is a Windows based machine. The OS should handle this for you. The only time the OS might...

It sounds too familiar ... as if it is using the the old replication algorithm of processing things ...

Here's a little start on the documentation side:

http://www.microsoft.com/sql/prodinfo/previousversions/systables.mspx

However it does not contain values for the column you mentioned. Maybe MSDN has the information. If not then it seems that...

The error that you are getting is due to either the fact that the directory does not exist or the account does not have write authority to your bcp target....

Here's a couple of code snippets that MS gave me as a workaround when I ran into this issue with the MOM (Microsoft Operatinos Management) database:

Set QUOTED_IDENTIFIER ON

Set  ARITHABORT...

The transaction log size has virtually nothing to do with an applicatino being sluggish. You are better off starting off with my 'short list' for tuning:

Round I

    DBCC UPDATEUSAGE

    UPDATE...

Here is what I have encountered in the past and feel is important to look at:

• Design - a balance between normalized and de-normalized data is needed.
• Table Partitioning - If it...

Don't forget the following configuration options as well:

 exec sp_configure 'min server memory (MB)', 3072

 exec sp_configure 'max server memory (MB)', 3072

 exec sp_configure 'awe enabled' , 1

 exec sp_configure 'set working set size',...

I do not have an answer but more questions.

• What OS version and SP are you running ?
• What version of SQL Server are you running and SP ?
• Are you running any...

The question passed spell check, but not prof reading ...

"if properly secured" should have been "is properly secured"

Thanks for the information.

It shows ones can still learn something new everyday !

When you install SQL Server EE (which is cluster aware) in an active/passive configuration there is not much left to do. If things show up in the Cluster Administrator, then...