Just thought I'd my ten cents worth. A case for Log shipping as a reporting solution.

Replication is obviously the preferred method of ensuring Data is in Sync. But...

Further to above post the issue is also manifest going from 64BIT SQL2005 SP2 to a 32 Bit SQL2005 SP2.

Same error and description.

CodeOn 😛

Situation:

Attempting to Use linked server from 64 bit SQL2005 to 32 BIT SQL2000 sp4

SELECT * FROM aussql1.aisdata.dbo.tblActiveDirectoryExtract

returns

OLE DB provider "SQLNCLI" for linked server "aussql1" returned message "Unspecified error".

OLE DB provider...

Rishi,

If you are use SQL 2005 then your problem can be solved using a Common Table Expression. Check BOL SQL 2005. These are awesome, other wise .....

Code On...

How about three - take your pick

1. How about the two most useless thing ever invented Broker services and Notification services. I even spend several $K...

IMHO we, as humble DBA's, are held accountable for 'patches' released by Software vendors. Rightly or wrongly, I expect the patch (or SP) to not introduce more bugs than...

Beer !;) - Always ! I don't care what language you use, its still beer. 😀 . Opps I think we digress ...

Oh Well 🙂

CodeOn:P

Analyse actually has no root ending -izo in greek as the greek 'usis' suffix precludes its use. The y is the english transposition of the greek 'u'

[Medieval Latin, from...

You might still have a problem.

http://support.microsoft.com/default.aspx?scid=kb;en-us;906954

The steps detailed in here is bad as is reverting code Master database to that of SQL2000 SP3-4. Fun enough it...

Once seen on an AirForce Trade test.

Question. Consider the following Hydraulic circuit, for the given range of inputs calculate the resultant output.

Answer. Strawberry jam ! ...

Ahhh!

Yup 😀 doin that. Except that the insert into Staging tables (updatable VIEW of delinquent timecards) originates from AUST (as that is where the Timecards a...

I haven't read the entire thread. But WOW all those nay sayers....:w00t: A simple point to consider - SQL server was never designed to be a 'Sequential...

Here is an oldie, and the start of all "End of Days" genre.

Earth Abides by George R. Stewart

Read enjoy.

CodeOn 😛

Most advisedly, and assured these DBCC commands are useful and yes I indeed use them as a part of the overall maintenance of my SQL Servers (at last count 33),...

I'm not saying don't use them but please read what they do and their recovery possibilities

DBCC Checkdb

Use the REPAIR options only as a last resort. To repair errors, we recommend...