Viewing 15 posts - 121 through 135 (of 769 total)
For the Logins, you could use sp_help_revlogin to script the logins from the source and...
June 7, 2018 at 10:40 am
April 11, 2018 at 1:33 pm
January 9, 2018 at 8:40 am
February 14, 2017 at 9:24 am
February 13, 2017 at 3:03 pm
What happened to the MY POSTS link that was in the forums of the old site that let you quickly access/review your past posts?
January 31, 2017 at 4:37 pm
We don't want the DB to be set to FULL or BULK LOGGED; the application keeps reverting the recovery model back to FULL and then Bulk Logged anytime we try...
August 23, 2016 at 1:46 pm
SOLUTION / ANSWER:
Turns out its was Systems Center that was using the NT AUTHORITY\SYSTEM account to execute 50+ queries each via its own Connection/SPID. Systems Center is using the...
June 29, 2016 at 12:02 pm
These logins are coming from the SQL Server box itself. Since posting I've had someone suggest it could be SCOM (Microsoft Systems Center ) which we do use. ...
June 27, 2016 at 4:30 pm
RESTORE LABELONLY FROM DISK = N'X:\MyDBBackupFolder\MyDBBackupFile.bak'
Thanks to everyone that offered up a possible solution but RESTORE LABELONLY ended up being the best solution. This command restores basic data about...
February 16, 2016 at 10:47 am
Jacob Wilkins (2/3/2016)
Just be aware that the dueling row numbers approach (2005_A in the article) does not guarantee the correct result if there are ties in the values...
February 16, 2016 at 9:48 am
Ok thanks.
November 30, 2015 at 11:46 am
Bob Snyder (5/30/2008)
I found this helpful. I had to add myself as an administrator to Analysis Services in the destination server...
That link no longer works but I did find...
October 21, 2015 at 1:37 pm
shari-509367 (4/7/2009)
If you are not in the server's Administrator...
October 21, 2015 at 1:27 pm
Luis Cazares (9/11/2015)
Personally, I try it to keep it simple by using the concatenation method explained in...
September 11, 2015 at 9:19 am
Viewing 15 posts - 121 through 135 (of 769 total)