Viewing 15 posts - 31 through 45 (of 110 total)
Steve Jones - SSC Editor (5/16/2011)
May 16, 2011 at 9:41 am
Steve Jones - SSC Editor (5/16/2011)
May 16, 2011 at 9:14 am
BTW, there is only one clustered index on the primary key with is an identity column.
May 16, 2011 at 8:05 am
Unfortunately, I desperately need space released back to the OS. Any other thoughts?
May 16, 2011 at 7:57 am
You do have to kick out all those connected users first and foremost:
alter database databasename set offline with rollback immediate
alter database databasename set online
exec sp_detach_db databasename
May 12, 2011 at 7:53 am
What about using DTS packages and dumping to Excel sheets as reports?
Both DTS and Excel look "free" enough 😛
May 11, 2011 at 7:32 am
I've recently done some patching on SQL Server instances which are engaged in a mirroring session. You only need to make sure that the sequence of transaction log on the...
April 29, 2011 at 5:57 am
Yes, it is applicable to all editions of SQL Server, Express included.
I have implemented this patching on my servers too.
April 29, 2011 at 5:41 am
If you are using SQL2008 where powershell script is supported and if your SQL Server service account has enough privilege on the mount points, you can schedule powershell scripts to...
April 29, 2011 at 5:34 am
free_mascot (4/28/2011)
Does adding additional primary/secondary file too applied on mirror?
Just tested on one of our mirrored pair, yes, the secondary file if added on principal is also added on the...
April 28, 2011 at 6:56 am
Steve Jones - SSC Editor (4/26/2011)
April 26, 2011 at 9:17 am
Steve Jones - SSC Editor (3/30/2011)
Have you tried uninstalling and reinstalling the tools? Perhaps there is something corrupted in the installation?I assume you are logging on as an admin, correct?
Hello...
April 26, 2011 at 8:24 am
am-244616 (4/20/2011)
Is there anyway to give ddl admin rights to the database user with out create/alter/drop table permissions.
The database user should only have
1. db writer
2. db reader
3. create/alter/drop view
4. create/alter/drop...
April 21, 2011 at 9:00 am
SQL Server running in single user mode accepts local windows admin account as sysadmin logins (even if group 'BUILT-IN\Administrators' is remvoed from sysadmin role).
So you need to have a local...
April 21, 2011 at 7:42 am
Viewing 15 posts - 31 through 45 (of 110 total)