Import/Export SQL Server 2000 Enterprise Manager Registered Servers
Exports and imports SQL Server 2000 Enterprise Manager groups and server registrations using Powershell.
2008-05-08 (first published: 2008-02-15)
2,652 reads
Exports and imports SQL Server 2000 Enterprise Manager groups and server registrations using Powershell.
2008-05-08 (first published: 2008-02-15)
2,652 reads
Perl script that reports SQL Server AD accounts which are now longer valid by verifying the output of sp_validlogins system stored procedure against SID stored in AD. This is done to ensure only accounts that do not exist are reported since sp_validlogins will only check the name and not SID against AD. Accounts that are […]
2007-02-12 (first published: 2006-08-08)
265 reads
XSLT Stylesheet to produce developer/object oriented html report from SQL Server 2005 Upgrade Advisor xml report file. Name the script sqlupad.xsl and insert the following as the first line in the xml Upgrade Advisor report file. Place sqlupad.xsl file in same directory as the xml report. This stylesheet works against Database Server component reportonly, does […]
2007-01-17 (first published: 2007-01-03)
215 reads
Troubleshooting intermitten connectivity issues can be difficult. One approach is to repeatedly test connecting to SQL Server outside of an existing application in order to verify if a server-wide intermitten issue is occurring. This script is used to test remote connectivity to a SQL Server. The script loops in one minute intervals (adjust as needed). […]
2006-09-04 (first published: 2006-08-08)
1,461 reads
Use this Perl script to produce an audit report of both share permissions and NTFS permissions of the shared folders. To report share permissions:Use shareperms.pl -p -SMyServer1 to report on a single server.Or use shareperms.pl -p -SMyServer1,MyServer2 for multiple servers.You can also use a text file as input: shareperms.pl -p -CServers.txtTo report NTFS permissions use […]
2006-06-27 (first published: 2006-06-11)
372 reads
Retrieve SQL Server port number from registry. Useful for SQL Servers running named instances or non-standard TCP port numbers.
2003-06-04
667 reads
T-SQL which scripts out all linked and remote servers. Works on SQL 7.0 and 2000. Remote login password is only decrypted on SQL 7.0.
2002-12-05
10,747 reads
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
Comments posted to this topic are about the item Adding Bits II
Comments posted to this topic are about the item An Unlimited Token Budget
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, true)
GO
See possible answers