The output you gave is not the output I got when I tried running your code. Seems awfully complex - were actually trying to run sp_executesql from within sp_executesql?

Anyway,...

I've got my server collation set to Latin1_General_CI_AS (I'm in New Zealand). Sharepoint didn't have a problem with this. It sets a different collation on the databases it...

It's been my experience (and I've seen it noted elsewhere in the forums here) that that is not entirely true. If you don't create the dependency, you can't...

Jeff Cook-476310 (1/7/2010)

---

I'm not sure what is going on but when I went to http://www.sqlservercentral.com/questions/T-SQL/68500/

and answered predicate (to the revised question), the site said:

Sorry - you were wrong

Correct answer: Operator

Explanation:...

Can we have some better vetting of the spelling/grammar of QotD? :crazy:

For this particular question, the REBUILDM.EXE program was not spelt correctly in either place it was mentioned.

It makes...

I had a similar experience. Installed SQL 2005 Developer on my laptop as default instance (already had a named instance of SQL 2000). No problem.

Installed SP3. All...

6 of one, half a dozen of the other. At least if you backup to the local [SAN] disk, you don't have to worry about a network blip fouling...

Interesting.

Not sure how clustering handles things under the hood, but from what I've seen, a cluster resource (file share at least) can be connected to by either the...

You need to reference the virtual name so that you are not tied to a single node in your cluster.

For example, say you have clusternode1 & clusternode2 in...

What error is being returned by the copy job?

Ensure that the network name your are using to get to the share on the primary is the Windows virtual name for...

That's pretty much the steps required.

In my experience with SQL Server 2005, SQL Server won't backup to a drive unless it is added as a dependency to the SQL Server...

Make sure NT AUTHORITY\SYSTEM has a SQL Login and rights to both databases being accessed. If the service account for SQL Server is NT AUTHORITY\SYSTEM (AKA LocalSystem), it should...

You could do a server-side trace. Give your view a unique name and setup the trace. Log to a file or to a table & make it one...

Can you actually use the SMTP server from the cluster? There may be relaying restrictions in place. You can test using telnet:

Open a command prompt window

Type in: telnet,...

On the primary server, you need to create a folder (or use an existing one) on a clustered disk to hold the log backups. This disk will need to...