In order to get the GRANT permissions you will need to query the system views (either server_permissions or database_permissions) depending on which level you need.

I believe this [/url]tip from K....

Offering a link to download the script as a whole, in place of copy/pasting, might be useful for folks. Good article though.

For clarification just taking the 70-450 does not get you the MCITP DBA 2008 certification. You can take it, but your transcripts with Microsoft are not going to show it...

You win the trip in space but your employer is not going to let you have the time off, estimating that you would need at least 1 week off. Would...

Nakul Vachhrajani (7/11/2011)This script is best used to eliminate I/O issues. If the backup file structure is logically corrupt, no point in even attempting a restore. Once we know that...

yes

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

A clustered index changes the structure of the table and how it is stored, which is why only one can exist on a table. A nonclustered index has the same...

You should see a 12288 Event ID (I believe) of packages or jobs that the SQL Server Agent is firing.

The SQL Server ERRORLOG has some system events written to...

There are not really any best practices to follow, that I know of. It is best to go by the business requirements of your organization. Finding the best license model...

I believe event id 128 or 129 are what you are looking for. I don't know where they show up in Profiler. I found them in BOL under the sp_trace_setevent.

Brian Brown-204626 (6/22/2011)

---

@@Servername shows the new name and we did use the sp_dropserver and sp_addserver procedures to change the name. As I stated, the old name is only in...

Does SELECT @@SERVERNAME still show the old server name?

The proper way to have done this is to use sp_dropserver and sp_addserver to properly allow SQL Server to update the server...

Yes I will agree with you the "example" I wrote up is probably not easy to follow. I wish I could have just provided the files in question but they...

I got a little help from Twitter, well alot of help actually...

Can you explain to me what the $new_content variable is doing?

What I ended up with after some help is...

I also did find one suggestion about first loading the file I'm trying to write back to into memory first (File_config.txt). I did this by just adding $x = (Get-Content...

Jeff Moden (6/13/2011)

---

Thanks again, Shawn. The real question is "How is SQLCMD being called?" Are you calling it through...