Viewing 15 posts - 16 through 30 (of 51 total)
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...
Bill Soranno
MCP, MCTS, MCITP DBA
Database Administrator
Winona State University
Maxwell 143
"Quality, like Success, is a Journey, not a Destination" - William Soranno '92
February 6, 2014 at 7:47 am
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...
Bill Soranno
MCP, MCTS, MCITP DBA
Database Administrator
Winona State University
Maxwell 143
"Quality, like Success, is a Journey, not a Destination" - William Soranno '92
April 9, 2013 at 6:57 am
Using the sql script worked.
Thanks
Bill Soranno
MCP, MCTS, MCITP DBA
Database Administrator
Winona State University
Maxwell 143
"Quality, like Success, is a Journey, not a Destination" - William Soranno '92
February 25, 2013 at 7:10 am
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...
Bill Soranno
MCP, MCTS, MCITP DBA
Database Administrator
Winona State University
Maxwell 143
"Quality, like Success, is a Journey, not a Destination" - William Soranno '92
February 21, 2013 at 1:48 am
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...
Bill Soranno
MCP, MCTS, MCITP DBA
Database Administrator
Winona State University
Maxwell 143
"Quality, like Success, is a Journey, not a Destination" - William Soranno '92
December 19, 2012 at 8:49 am
Nice script.
I found on my servers, 2008 R2, I had to divide growth by 128 to reflect the value shown in the UI.
Bill Soranno
MCP, MCTS, MCITP DBA
Database Administrator
Winona State University
Maxwell 143
"Quality, like Success, is a Journey, not a Destination" - William Soranno '92
October 1, 2012 at 6:51 am
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...
Bill Soranno
MCP, MCTS, MCITP DBA
Database Administrator
Winona State University
Maxwell 143
"Quality, like Success, is a Journey, not a Destination" - William Soranno '92
June 28, 2012 at 6:47 am
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...
Bill Soranno
MCP, MCTS, MCITP DBA
Database Administrator
Winona State University
Maxwell 143
"Quality, like Success, is a Journey, not a Destination" - William Soranno '92
May 18, 2012 at 7:00 am
Sean
I would just like to say ditto!
Bill Soranno
MCP, MCTS, MCITP DBA
Database Administrator
Winona State University
Maxwell 143
"Quality, like Success, is a Journey, not a Destination" - William Soranno '92
May 15, 2012 at 10:10 am
Nils,
You put the complaint in before I could.
Thank you.
Bill Soranno
MCP, MCTS, MCITP DBA
Database Administrator
Winona State University
Maxwell 143
"Quality, like Success, is a Journey, not a Destination" - William Soranno '92
March 6, 2012 at 6:33 am
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...
Bill Soranno
MCP, MCTS, MCITP DBA
Database Administrator
Winona State University
Maxwell 143
"Quality, like Success, is a Journey, not a Destination" - William Soranno '92
February 14, 2012 at 7:21 am
Is the event on March 24th 2012?
Bill Soranno
MCP, MCTS, MCITP DBA
Database Administrator
Winona State University
Maxwell 143
"Quality, like Success, is a Journey, not a Destination" - William Soranno '92
January 11, 2012 at 7:14 am
Phil,
Here is a much simpler function.
ALTER FUNCTION [dbo].[fnConvertTabToSpaces]
(
@String VARCHAR(8000)
,@NumSpaces INT
)
RETURNS VARCHAR(8000)
AS
...
Bill Soranno
MCP, MCTS, MCITP DBA
Database Administrator
Winona State University
Maxwell 143
"Quality, like Success, is a Journey, not a Destination" - William Soranno '92
September 29, 2011 at 10:35 am
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,...
Bill Soranno
MCP, MCTS, MCITP DBA
Database Administrator
Winona State University
Maxwell 143
"Quality, like Success, is a Journey, not a Destination" - William Soranno '92
June 21, 2011 at 9:17 am
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...
Bill Soranno
MCP, MCTS, MCITP DBA
Database Administrator
Winona State University
Maxwell 143
"Quality, like Success, is a Journey, not a Destination" - William Soranno '92
June 21, 2011 at 7:17 am
Viewing 15 posts - 16 through 30 (of 51 total)