Forum Replies Created
Viewing 15 posts - 31 through 45 (of 51 total)
-
RE: SQL DBAdmin toolbox - Part 2: Verify all databases in the enterprise
The article is interesting. I have an issue with the code.
I copied it to my clipboard.
When I pasted it in to a new query it looks like this:
I even pasted...
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
-
RE: Restricting SQL Server TCP/IP Port Range
Carl,
I need to use your suggestions, for firewall reasons, but my environment is more current.
I have an active/active cluster for sql. The 2 servers in the...
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
-
RE: Query Active Directory to Display Login Information
Rudy,
You should edit you post so the code is multiple lines. One long line is diffucult to read.
Here is a multi line version.
PRINT 'Active Directory Query...
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
-
RE: Script DB Level Permissions
I like the script, it will be useful.
I have added the following to your code:
DECLARE@sql VARCHAR(2048)
,@sort INT
DECLARE tmp CURSOR 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
-
RE: Error 29538 while installing Hotfix
I moved them so they were all in the same location and the patch applied.
Thanks for the help.
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
-
RE: Error 29538 while installing Hotfix
I have not renamed the file. It is in the original location from installing SQL (C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data).
I have moved the system databases to F:\MSSQL_Data. and the logs to...
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
-
RE: Error 29538 while installing Hotfix
I am getting this error, from Summary.txt, while trying to install KB970892:
**********************************************************************************
Product Installation Status
Product ...
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
-
RE: Display rows vertically
Bruc0Blachf0rd-780736 ,
Do not pass dbo. as part of the table name.
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
-
RE: The Complete SQL Server 2005 Permissions Report
I am using SQL Server 2005 Enterprise Edition (x64) and getting the following errors:
Msg 102, Level 15, State 1, Line 11Incorrect syntax near '?'.
Msg 102, Level 15, State 1, Line...
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
-
RE: Estimating the table size...
Here is a cleaned up set of code.
CREATE FUNCTION [dbo].[fn_CalculateHeapSize](
@Tablename VARCHAR(100)
)
RETURNS VARCHAR(100)
AS BEGIN
-- Calculate the space used...
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
-
RE: Estimating the table size...
After cleaning up the text of the functions so it would create them, the function fn_GetTableSize only returns NULL.
I changed the function so the calculations handle a NULL return.
ALTER...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
-
RE: Manipulating Integer8 (Active Directory)
I ran into similar problems getting the accountexpires value.
I created the following function:
CREATE FUNCTION [dbo].[UTC2date] (@numSeconds BIGINT)
RETURNS DATETIME
AS BEGIN
DECLARE @TimeBias AS INT
EXEC...
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
-
RE: LDAP-Query-page size problem
I run the following query and it will return 17,000 plus records:
SELECT
sAMAccountName
,DistinguishedName
,dbo.UTC2date(accountExpires)
,employeeID
,cn
FROM
...
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
-
RE: Script permissions on all databases
Mark,
You may need to increase the [Object] field or the [Column] field in table #t.
It will depend on the length of the names you use for your objects and columns.
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
-
RE: Script permissions on all databases
Nice script.
But I had to increase the size of a2 to 75 to avoid truncation errors on SQL 2005.
Here is an updated script. I changed the names of the fields...
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
Viewing 15 posts - 31 through 45 (of 51 total)