It seems pretty straight forward to me. If someone leaves the company or moves to another department and no longer should have access to resources they used before, what...

I thought of creating scripts or an SP that contains the backup commands and giving them execute rights on it, but my idea was to give them a easy GUI...

Find the user Active Directory, right-click and look at the Member Of tab.

You have an ORDER BY clause with a field from the joined table. Since ORDER BY can't evaluate null, I think this is making it an inner join.

I'd leave...

I have Trancender and have been annoyed by syntax-type questions that would not be real-life issues if you often refer to BOL when you work (I did not feel that...

This command returns the machine name for me. Interestingly, if you run it on a Named Instance or a multi-node clustered instance it returns the...

On a related note, I've discovered a hole in the 10GB limit. We have a user with a SQL 2008 R2 Express instance on his workstation whose been...

Wouldn't an ALTER DATABASE operation be better for this?

http://msdn.microsoft.com/en-us/library/bb522469.aspx

You would still need access to the drives where the files are located.

I just opened Device Manager on a VM I use and saw "VMWare" listed in the descriptions for the Disk Drive, Display and DVD/CD-ROM devices.

Uninstalling a failed SQL installation so that you can successfully re-install successully can be tricky. Be sure to:

1) Remove the instance using the Setup application.

2) Delete the Program Files/Program...

My impression is that SQL SPs will update all editions of SQL Server (Express/Standard/Enterprise, etc.), provided they are the the correct base version (2008/ 2008 R2/2012), and compilation (different SP...

It sounds like the scenario in which you would do this would be if the disk containing the filegroup (but not all the other filegroups) is lost. The transaction...

Also make sure you created the SP on the correct schema and that it has the right permissions for the Crystal logon\user.

I realized that if erroneous text were in your column, my code might produce an incorrect result. Here is an improved version:

declare @string varchar(max)

declare @openbracket int

declare @closebracket int

set @string...

"Amusing" deadlocks?