What version of Windows are these running on? Or, more importantly- are you sure the disk partitions are aligned [in both environments]? Nothing leads me to suspect this is your...

select 'select ''' + a.TABLE_NAME + ''' as TABLE_NAME from [' + a.TABLE_SCHEMA + '].[' + a.TABLE_NAME + '] where COMPKEY = 270188 union'

from INFORMATION_SCHEMA.TABLES a

join INFORMATION_SCHEMA.COLUMNS b

on...

You could write an installation script for this, assuming the client has network access to a copy of the media something like (below) would install only management studio;

\\yourserver\share\folderwithmedia\setup.exe /Action="Install" /IACCEPTSQLSERVERLICENSETERMS...

Remove...

7 years now, and still relevant.

nzrdb6

Has the service profile of srv2 been allowed to delegate the spn's of srv3?

When you checked sys.dm_exec_connections for auth scheme, did you do this from PC1->srv3 and also from srv2->srv3?...

Looks like that should all work, but two things seem odd.

1) That error doesn't sound familiar. I was curious enough to try to build one of these in BIDS and...

I recently had a problem where a SQL Server was falling back to NTLM. The solution was rather simple, and in case its of help (I don't think I've seen...

I realize this thread is over a year old now, but in case its of help to anyone; in full recovery mode the filestream files get removed after a checkpoint...

I ended up reorganizing or rebuilding based on fragmentation level;

< 5% or < 30 pages = do nothing

+ < 40% fragmentation = reorganize

+ > 40% fragmentation = rebuild

This reduced...

For a different reason I ended...

Hi Anish,

I'm curious what solution you ultimately went with and how this is going. I'm in a similar position where I have a large database I'm mirroring, and it...

Adam Bean (3/24/2008)

---

Ok, I looked at each column that has a computed column, and none of them contain a double quote ... yet they all have single quotes for strings....

I followed this and worked without problem. Same instructions from msdn; http://blogs.msdn.com/petersad/archive/2009/02/25/sql-server-2008-creating-a-merged-slisptream-drop.aspx, with pictures.

If it's of help, the reason I needed to do this was I was getting this...

Provided that that last step is reached On Success...