It's in SQL Server Books Online:

When RESTRICTED_USER is specified, only members of the db_owner fixed database role

and dbcreator and sysadmin fixed server roles are allowed to connect to the...

I've got a trigger setup on ALTER LOGIN events. I'm using Database Mail to send me an email notification. Here's the code:

[font="Courier New"]CREATE TRIGGER [tddl_alterloginnotification]

ON ALL SERVER

FOR ALTER_LOGIN

AS

...

No. SQL Server security is handled by SQL Server. The only thing a GPO can influence is the password policy of the machine SQL Server is installed on....

How often are you restoring these databases? Is it on a regular basis? As in scheduled job regular basis? If so, add an additional step to create...

Side note - typically, domain\servername$ accounts are used by the Network Service builtin account. So if any service is configured to use Network Service as its account and it...

Also make sure the folder structure exists - backup will not create any folder structure you specify in the backup command, it has to exist first.

Get rid of the "=" from the statement. It should read:

[font="Courier New"]ALTER DATABASE SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS[/font]

Assuming that you were posting verbatim to this forum what you were...

I'd also add [font="Courier New"]AND mst.state_desc = 'ONLINE'[/font] to the WHERE clause (or [font="Courier New"] AND DATABASEPROPERTYEX(name, 'Status') = 'ONLINE'[/font]. The first way is SQL 2005 only).

Yeah, 'dob? WTF is 'dob'? Commonly it's short for 'date of birth', which has nothing to do with when an employee joined a company.

Use RESTORE HEADERONLY. Check the DifferentialBaseGUID from the differential backup matches the BackupSetGUID from the full backup.

Thanks for the feedback Gail.

I forgot you can do joins like that (can you tell I don't do this sort of thing too often?).

There already is an index for PreviousDocumentNumber,...

Thanks for the feedback Gail.

I forgot you can do joins like that (can you tell I don't do this sort of thing too often?).

There already is an index for PreviousDocumentNumber,...

Seen this before. Fire up Task Manager & check to see if there is still a rar.exe process running. If so, more than likely that is holding locks...

Try looking in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall

There are a number of GUIDs under that. For me, SQL was under {2373A92B-1C1C-4E71-B494-5CA97F96AA19}.

Find the key & check the data in the InstallSource value.

You...

It looks like you are trying to install shared files to a non-shared drive (C: drive, looking at the last error).

Have you setup & configured a shared disk for SQL...