Viewing 15 posts - 2,716 through 2,730 (of 9,253 total)
Maddave (11/21/2014)
There is still one or more connections to the database. Exec sp_who2 and look to see what connections are connected to your database.
Not if this completed successfully
USE [master]
ALTER...
November 21, 2014 at 9:05 am
Siberian Khatru (11/21/2014)
1. How does switching TDE on affect the backup set(s) for a database?
Once TDE is enabled in the database all backups will be dependant upon the certificate...
November 21, 2014 at 8:28 am
sminar (11/21/2014)
November 21, 2014 at 8:15 am
plamannkathy (11/21/2014)
USE [master]
RESTORE DATABASE [TESTFULL] FROM DISK = N'TESTFULL_FULL_20141120_190322.bak'
WITH FILE = 1, NORECOVERY,...
November 21, 2014 at 8:12 am
charipg (11/21/2014)
we can find free space on disks with 'xp_fixeddrives'.i need script to find all disk size(total size\capacity) in the servers, any help ?
easy via Powershell
Get-Volume | ?{$_.DriveType -EQ...
November 21, 2014 at 7:06 am
This should be the database engine url not the mirror endpoint as you have specified
READ_ONLY_ROUTING_URL = N'TCP://SQL01.contoso.local:5022'));
So, as an example, if i set my sql server instance called bob on...
November 21, 2014 at 7:01 am
The ReadOnly routing URL setup is a manul process via PowerShell or TSQL, your readonly routing url and your mirror endpoint urls are the same, this is incorrect! Refer back...
November 21, 2014 at 6:50 am
would have thought the biggest issue here is that conversion is not allowed from type date to type bit!
November 21, 2014 at 6:44 am
was this database originally a sql server 2000 database?
November 21, 2014 at 6:00 am
arrjay (11/20/2014)
November 20, 2014 at 3:45 am
robin.pryor (11/19/2014)
So there's just no way to disable a Windows Group login?
only deny, but be careful here. Please see this link
November 19, 2014 at 2:07 pm
windows groups cannot be denied as detailed here
The link states;
MSDN - ALTER LOGIN (Transact-SQL)
November 19, 2014 at 10:48 am
no it's a temporary workspace
November 19, 2014 at 10:36 am
ramana3327 (11/17/2014)
I am working with SSRS. I do have admin rights. I can connect to the url https://localhost/Reports and can create the new reports and subscription. Delete the reports and...
November 19, 2014 at 5:32 am
Viewing 15 posts - 2,716 through 2,730 (of 9,253 total)