Viewing 15 posts - 7,186 through 7,200 (of 9,253 total)
only the master database and the error log location are held in the registry along with default data and log and backup paths. Tempdb location is taken from the master...
April 5, 2011 at 3:00 am
no, i put "" around the url which is ok for Safari but IE doesnt like it :crazy:
April 4, 2011 at 8:33 am
Windows 2008 clusters no longer use a domain account it runs as local system.
See the following KB from Microsoft for further info
April 4, 2011 at 8:15 am
M.Kahn (4/4/2011)
You mean i have to login every server and run that syntax or
Yes, pretty much or alternatively
As i said if you have SQL Server 2008 central management server...
April 4, 2011 at 8:09 am
my apologies i have fixed the link now
April 4, 2011 at 8:08 am
M.Kahn (4/3/2011)
April 4, 2011 at 6:17 am
EvilPostIT (7/19/2010)
I'll take that as a no then...
How many filegroups\files do you currently have in use for this database?
Toothpicker (4/3/2011)
April 4, 2011 at 6:10 am
The following will get you login names, SIDs and hashed passwords
select name, sid, password_hash from sys.sql_logins
April 3, 2011 at 1:19 pm
check the sql server log again carefully, if the backup command failed it will be in there!
April 2, 2011 at 3:07 pm
if all the instances are registered under a SQL Server 2008 central management instance use the following query to add the group and assign sysadmin privileges
CREATE LOGIN [domain\group] FROM WINDOWS
EXEC...
April 2, 2011 at 2:45 pm
the virtual network name already exists, ping it and see if it replies.
If it doesn't and to proceed and use this network name, delete the computer account from AD and...
April 2, 2011 at 2:39 pm
Group or application it amounts to the same thing. Either way I would do what I posted above 😉
April 1, 2011 at 5:25 pm
for XP Home, boot into safe mode to set share\folder permissions via the share and security tabs and then reboot normally
April 1, 2011 at 5:09 am
are you attempting to add a node to an existing clustered instance of sql server?
April 1, 2011 at 4:15 am
Viewing 15 posts - 7,186 through 7,200 (of 9,253 total)