Alex,

All listed criticisms listed above aside ( I do not necessarily agree with them), I thought your article was interesting to read. I have used delimited...

Nice script.

To get it to run properly I had to comment out lines 9, 13, 39 and 40. /* and */ are not valid in powershell. Lines 39 and...

Using the sql script worked.

Thanks

I must be missing something. I have just finished rebuilding my publishing sql server on sql server 2008 r2. When I try to add one of my sql server 2012...

Lowell,

I just found your script and will be adding it to my collection. Thank you for the work.

I did make one change. I removed the cte...

Nice script.

I found on my servers, 2008 R2, I had to divide growth by 128 to reflect the value shown in the UI.

I have the self contained version of KeyPass installed on my flash drive I carry with me. That way I can run the program from the flash drive no matter...

Nice editorial.

For the end users, that are allowed direct access to a sql server, domain accounts are required. They are granted access thru AD groups, so their account does not...

Sean

I would just like to say ditto!

Nils,

You put the complaint in before I could.

Thank you.

The exact message states:

Deleting a remote server deletes all remote logins defined for that server. Are you sure you want to delete this linked server and all remote logins for...

Is the event on March 24th 2012?

Phil,

Here is a much simpler function.

ALTER FUNCTION [dbo].[fnConvertTabToSpaces]

(

@String VARCHAR(8000)

,@NumSpaces INT

)

RETURNS VARCHAR(8000)

AS

...

Zhong,

I ran your process for one of my smaller sql servers and it worked great.

I have a question for you.

In the RestoreConfig table you have two columns, DatabaseName and DBExclude,...

Zhong,

I was able to do a find and replace for the lines that appeared in the code.

I am in the process of going thru the procedures...