Viewing 15 posts - 16 through 30 (of 345 total)
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,...
January 27, 2010 at 7:04 pm
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...
January 27, 2010 at 5:32 pm
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...
January 13, 2010 at 6:17 pm
Jeff Cook-476310 (1/7/2010)
and answered predicate (to the revised question), the site said:
Sorry - you were wrong
Correct...
January 7, 2010 at 2:35 pm
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...
August 11, 2009 at 8:48 pm
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...
July 20, 2009 at 9:03 pm
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...
July 1, 2009 at 1:29 pm
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...
June 30, 2009 at 7:58 pm
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...
June 30, 2009 at 1:35 pm
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...
June 29, 2009 at 4:37 pm
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...
June 28, 2009 at 4:09 pm
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...
June 25, 2009 at 8:08 pm
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...
June 25, 2009 at 7:58 pm
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,...
June 25, 2009 at 7:37 pm
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...
June 25, 2009 at 7:24 pm
Viewing 15 posts - 16 through 30 (of 345 total)