However it's late to point it but there are two threads running for same issue in SSC. Both have more than 5 replies. 😀

This is the early thread.

http://www.sqlservercentral.com/Forums/Topic1227680-392-1.aspx

forsqlserver (12/30/2011)

---

Thanks Dev...it is really helpful.

In this it is asking for user_id and password and I want to schedule it using job in automatic completion of backup.

How can user_id and...

Michael Valentine Jones (12/29/2011)

---

...

This error is an indication of a network problem:

[font="Arial Narrow"]"The operating system returned the error '64(The specified network name is no longer available.)' while attempting 'FlushFileBuffers' "[/font]

It...

It's not relevant to your error but you should rewrite the JOIN as well. It may be a CROSS JOIN.

FROM dbo_HomePhone hp, dbo_Subscription sub, dbo_Address_G1 ad, dbo_PhoneDelivery pd

LEFT OUTER JOIN...

You can regenerate it.

Example:

USE AdventureWorks2008R2;

ALTER MASTER KEY REGENERATE WITH ENCRYPTION BY PASSWORD = 'dsjdkflJ435907NnmM#sX003';

GO

For More: http://technet.microsoft.com/en-us/library/ms186937.aspx

DON'T try it on PROD server until you verify the above on a test...

Can you please post the table structure (DDL) for 'dbo.METHOD'?

The typical encryption / decryption application follows either of two scenarios.

•Front End sends raw data & database server encrypts few fields based on requirements. In data retrieval, decryption happens at...

By looking into code & your description I can confirm that it’s not SQL Server limitation. You didn’t get ‘SqlException’ that indicate database errors. The Error says ‘COMException’ so I...

Any particular reason for that?

PaulB-TheOneAndOnly (12/29/2011)

---

I remember having to do it a few years ago.

Didn't use a third party tool but a set of three stored procedures: sp_hexadecimal, sp_help_revlogin and a sligthly hacked version...

Do you want to create backup on Network Drive or do you want to copy backups on Network Drive?

If first, it’s not advised. The solution on second scenario depends on...

Just to add what Jon said, persisted computed columns actually consume disk space. If your query has search predicates on computed columns then it would be a good idea (with...

chintalapati.srikanth (12/30/2011)

---

I have the following fields in my table.

UserName DateTime Action

abc ...

Please post DDLs, sample data & Execution Plans (actual) as well. It’s required for performance tuning exercise.

GilaMonster (12/29/2011)

---

Stefan Krzywicki (12/29/2011)

---

I can't even get them to...