there's an MSDN link for mirroring from 2005 to 2012, so it must be supported...

http://msdn.microsoft.com/en-us/library/bb677181.aspx

I take it you've looked in the "system databases" folder. Can you see msdb, tempdb and model?

GilaMonster (4/28/2013)

---

1) DBCC DBREINDEX is deprecated, is included only for backward compatibility with SQL Server 2000 and should not be used any longer

2) Up to you. Depends on your requirements...

have you updated the statisics?

do you have the sqlcmd.exe folder in the %path% environment variable? If not, add it, or try using the full path

I've never tried with a differential backup, but it makes sense that it should work: See the following from http://msdn.microsoft.com/en-us/library/ms187495.aspx:

1.Back up the active transaction log (known as the...

could you try putting NULLIF round the bit that's causing the divide by zero error?

found that the datasource precision wasn't set. Thanks

The users will be responsible for clearing out the directory these files are stored in. My instructions are to load whatever's in that directory every time the solution runs,...

Hi,

The linked server is set up to use the Windows login's current security context. On the face of it, Kerberos seems to be working ok. sys.dm_exec_connections shows several...

any thoughts? thanks

perfect. Thank you

I haven't, but only because I'm trying to mimic the behaviour of this 3rd party monitoring software. It uses ye olde style trace under the hood, and I'm not...

i'm leaning towards that, too. But, what's different in 2008 R2? It worked running under 2005

Hi,

I've already tried a variety of maxdop and affinitiy options, to no avail. I can reproduce this problem in our test environments, which only have 2 vCPUs...