Viewing 15 posts - 4,561 through 4,575 (of 7,168 total)
You said you already knew about backing up and restoring msdb, however did you know you could restore msdb with a name other than msdb? This would allow you to...
April 9, 2012 at 12:55 pm
April 9, 2012 at 12:49 pm
Jeff Moden (4/8/2012)
April 9, 2012 at 12:42 pm
I ran the demo code and it works as advertised (i.e. emails a file with an xls extension) but when I open the attachment in Excel 2010 I receive this...
April 9, 2012 at 12:33 pm
Perry Whittle (4/9/2012)
opc.three (4/9/2012)
April 9, 2012 at 12:11 pm
Perry Whittle (4/9/2012)
opc.three (4/9/2012)
however what if you had multiple files to move and missed one?
The database would not come online!
The only time this would differ in any way is with...
April 9, 2012 at 12:02 pm
Perry Whittle (4/9/2012)
alter database DatabaseName set single_user with rollback immediate
go
-- Set databae Offline
alter database DatabaseName set Offline
go
---...
April 9, 2012 at 11:48 am
Perry Whittle (4/9/2012)
opc.three (4/9/2012)
April 9, 2012 at 11:29 am
ravisamigo (4/9/2012)
Please advise how to find who restared the services and what might be the cause behind this change?
You will be able to see it in the Windows System Event...
April 9, 2012 at 9:53 am
You're very welcome, happy to assist 🙂
To drive the point home, once again...remember this was a special case. You said you have read many articles about the perils of shrinking...
April 9, 2012 at 9:47 am
Perry Whittle (3/28/2012)
SSRfromChennai (3/28/2012)
how to validate a windows login in domain through SQL queriesuse the stored procedure xp_logininfo
xp_logininfo only validates windows accounts after the SQL Server Login is created.
April 9, 2012 at 9:42 am
Perry Whittle (3/30/2012)
You shouldn't need to set the database single user first, just issue the following
alter database set offline with rollback immediate
[/Code]
That would accomplish setting it offline and kicking out...
April 9, 2012 at 9:38 am
This exact question came up on these forums a while back. You may be able to wiggle out of doing a full uninstall/reinstall, however do not take licensing advice from...
April 9, 2012 at 9:10 am
Perry Whittle (4/7/2012)
As an extra option you could turn SORT_IN_TEMPDB on, this may offload somewhat to the TempDB rather than using the database filegroup
Ahhh, you beat me to it. I...
April 7, 2012 at 6:54 am
For development and exploring on an XP workstation i would recommend SQL Server 2008 R2 Express Edition
April 6, 2012 at 9:56 pm
Viewing 15 posts - 4,561 through 4,575 (of 7,168 total)