This ActiveX Script runs in DTS Designer and will clean up all unused connection objects. This allows you to rename connections at will by selecting "New Connection" and typing a new name. It also allows you to copy and paste connections then rename them. Then you can cleanup leftover connections when development is complete.
2007-06-12 (first published: 2005-01-05)
464 reads
This script checks the latest backup of all databases. Then it write a logfile with this timestamp. all backups older than one day will be marked as ERROR.
2007-06-11 (first published: 2005-06-30)
618 reads
This script helps you synchronizing ALL orphaned database users to syslogins of the new database server. To run it, pass the target database name in on the first line.
2007-06-08 (first published: 2005-08-27)
547 reads
This stored procedure will loop through all of the Analysis Services databases in the repository and back them up to a .cab file using the msmdarch command. A log file will be included with the backup.There will be 2 days worth of backups saved to a local disk drive on the server.It may be necessary […]
2007-06-07 (first published: 2005-05-25)
425 reads
Import database from source server using full and transaction log backups as recorded in msdb. Use it to import one or more databases to your development environment, to test your backups regularly or to move databases to a new server. Works on SQL 7 and SQL 2000 with native and/or LiteSpeed full backups and native […]
2007-06-06 (first published: 2005-06-29)
659 reads
This was just an answer in a forum in September, but I keep getting requests for the script. So I am sharing it here for anyone that could be interested: Problem: large amount of registered servers, multiple DBA's needing updated registration info, DBA workstations added or rebuilt, many servers added at once. In cases like […]
2007-06-05 (first published: 2005-01-26)
899 reads
User-Defined string Functions MS SQL Server 2005 Transact-SQL SQLCLR (VB. Net, C#.Net, C++. Net) Ladies and Gentlemen, I am pleased to offer, free of charge, the following string functions MS SQL Server 2005 Transact-SQL SQLCLR (VB. Net, C#.Net, C++. Net): AT(): Returns the beginning numeric position of the nth occurrence of a character expression within […]
2007-06-04 (first published: 2006-02-03)
646 reads
This procedure is useful to find the dependents on a particular column in a table and deletes the dependents like 'Index','Relation ships'.This is developed in Sql Server 2005
2007-06-01 (first published: 2006-03-10)
200 reads
-- The goal is to avoid the use of sp_start_job in an application. So we have the application use RAISERROR to activate the job.-- 1) because you can only start jobs you own-- 2) we don't want to open the cmdshell to everyone-- 3) we want control regarding jobs that run on our server.-- 4) […]
2007-05-31 (first published: 2004-01-21)
2,133 reads
Post data as coming from an HTML FORM with METHOD=POST to an URL and retrieve the result. The script uses the WinHttp.WinHttpRequest.5.1 object.Call like :exec dbo.usp_httppost 'http://www.sqlservercentral.com/search/turbo.asp','searchstring=ftp&btnG= Go &cArticles=on&cForums=on&cScripts=on&sitesearch=http://www.sqlservercentral.com'
2007-05-30 (first published: 2005-01-19)
1,788 reads
By James Serra
There are three Azure SQL products with so many different deployment options, service tiers,...
By Steve Jones
I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....
By Steve Jones
I was asked to do some a little thinking and brainstorming recently. Rather than...
Hi, Does anyone have experience with MEMORYBROKER_FOR_RESERVE ? when suddenly there is somehow constantly...
I just learned that my database was created on my C:\ drive in the...
I am needing to migrate a MSSQL db to MySQL, on a different server...
I have a complex database with a few filegroups and files. Can I run a backup command like this? (assume file/filegroup names are valid).
BACKUP DATABASE [complex]
FILE = N'thirdone'
, FILE = N'thirdtwo'
, FILEGROUP = N'second'
TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL16.SQL2022\MSSQL\Backup\complex.bak'
WITH NOFORMAT, NOINIT, NAME = N'complex-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
See possible answers