Viewing 15 posts - 31 through 45 (of 101 total)
Thanks for the reply. I should've been more detailed. The SP needs to run on job schedule. It's not a one-time thing.
February 11, 2014 at 11:26 am
And I messed up an identifier...
, ROW_NUMBER() OVER (ORDER BY b.SPID), 0 AS LevelRow
Same locking issue still
February 4, 2014 at 9:56 am
I can add that it is not self-blocking.
February 4, 2014 at 9:46 am
Encryption key. Had to backup old key and restore to new server using reporting configuration manager.:crazy:
November 26, 2013 at 12:45 pm
Almost, but the select statement joins from 2 databases. I do appreciate the reply.
November 6, 2013 at 1:38 pm
I am having the same issue:
OLE DB provider "DB2OLEDB" for linked server "sqlserver01" returned message "An internal network library error has occurred. A network level conversational protocol error has occurred....
November 1, 2013 at 11:42 am
Is the TempDB set to be able to grow the files?
August 19, 2013 at 12:45 pm
SQL Browser being on or off does not influence the findings when we run this tool.
That used to be the case, a couple years ago anyway. Haven't verified that...
July 25, 2013 at 11:24 am
s.youngman (7/25/2013)
I have a similar powrshell script that I run from cmd line on an adhoc basis.I get round the subnet issue like this
Very nice!
July 25, 2013 at 7:30 am
Thanks! I will give that a try.
June 25, 2013 at 1:53 pm
Thanks for the ideas, will try them. There are 5 files in 3 different filegroups, is there a way to just restore 1 filegroup at a time to a...
June 25, 2013 at 10:56 am
By remote, do you mean you query through a Linked Server?
December 10, 2012 at 9:11 am
Viewing 15 posts - 31 through 45 (of 101 total)