Viewing 15 posts - 46 through 60 (of 118 total)
Microsoft SQL Server Release Services
( http://blogs.msdn.com/b/sqlreleaseservices/ )
has missed the last release of a Cumulative Update for both SQL 2008 R2 (Dec) and SQL 2008 (this month)....
January 24, 2012 at 8:54 am
robgilbie (1/12/2012)
backup database MSDB to disk = N'c:\sql...
January 13, 2012 at 5:29 am
free_mascot (12/22/2011)
You can use SSIS to transfer logins.
I don't prefer this method because the logins are disabled, and their passwords are scrambled. The "sp_help_revlogin" method avoids those two issues.
If that's...
December 23, 2011 at 5:47 am
A deer rifle, and a generator.
Merry Christmas to all. Remember the Reason!
December 23, 2011 at 5:28 am
Thanks. I have tried running as SERVERNAME\Administrator, and the results are the same.
September 19, 2011 at 7:07 am
I have extracted the SP1 setup file to a folder by running SQLServer2008R2SP1-KB2528583-x86-ENU.exe -extract. Now I can go direct to setup.exe and run it.
I see a command window blink, then...
September 19, 2011 at 6:21 am
OomBoom (9/19/2011)
I would suggest login on to the server as the local administrator. Make sure the service accounts has the correct rights. The only place I have seen this before...
September 19, 2011 at 5:27 am
1) "It depends".
2) "No", probably.
3) ModelID was "probably" a typo.
Both the actual table structure and the data contents were unknown. I'm fairly sure I could provide schemas and data sets,...
July 25, 2011 at 6:09 am
That's a nice, concise page. I have several of these bookmarked but this one is quick to...
July 20, 2011 at 6:36 am
So, does he think he's being punished instead of honored?
May 16, 2011 at 5:16 am
Jeffrey Williams-493691 (3/21/2011)
March 22, 2011 at 5:35 am
Craig - many thanks!
I'll be saving and studying the info you provided.
FWIW, the 3rd party software vendor now tells me they are familiar with this behavior.
He asked me...
March 3, 2011 at 12:02 pm
Craig Farrell (3/2/2011)
Mike Hinds (3/2/2011)
(No column name)(No column name)usedtotalqueue_messages_846626059339836631990103199419
sysdercv6796973484825484888
sysdesend67969734883648856
sysconvgroup67969733140131408
sysobjvalues2596186
What are they, and what can I safely do with them?
:blink: Do you have Service Broker active on this database? Check...
March 3, 2011 at 5:55 am
Robert klimes (3/2/2011)
March 2, 2011 at 1:34 pm
Ninja's_RGR'us (3/2/2011)
How big are the diffs and log (avg daily).
Mon diff = 200 MB
Tue diff = 4.6 GB
Today's log backups - idling 58k, between 10 and 14 MB during business...
March 2, 2011 at 8:43 am
Viewing 15 posts - 46 through 60 (of 118 total)