This stored procedure lets you retrieve the environment variables from the server. you can pass in a partial name to get the variables that start with the partial match, or bblank to retrieve all the environment variables.
2002-12-18
485 reads
The script is design to gather informations on the growth of the databases per server (except the system ones).It is collecting in the 'databases' table of the master database for current information and in 'histodatabases' for old ones.It is possible to schedule the stored procedure.The column Serveur is only for gathering information on one server […]
2002-12-17
328 reads
Came across a great script from Ken Kaufman on copying backups using xp_cmdshell. Thought I'd contribute a script I wrote that builds on that to restore the latest production backup to a testing or development server. In this case I routinely create all my production backups to a network share and then use that source […]
2002-12-16
652 reads
This script will backup all databases that are online and have a recovery property of 'SIMPLE' AND already have a full backup. This script is set to run Monday thru Saturday at our site.
2002-12-12
220 reads
This script will do a full backup of any new database(s) on the server that does not have a backup already. This script runs Monday thru Saturday at our site.
2002-12-12
237 reads
This UDF will validate a credit card number using Luhn's formula.For example 49927398716 will return 1:print dbo.luhn('49927398716')print dbo.luhn(49927398716)11based on:Credit cards, validation and the Luhn formulabyEduardo Chaveshttp://www.webdevelopersjournal.com/articles/validation.htmlAlgorithm converted to TSQL by Joseph Gama
2002-12-12
543 reads
This script will backup all databases that are online (sql 2000). So if a new database is added you will get a backup. This is setup as a weekly job at our site (Sunday night).
2002-12-12
362 reads
ASCII table and UNICODE tableYou can easily change the font of "SQL Query Analyzer":TOOLS/OPTIONS/FONTS
2002-12-11
501 reads
This SP will create an Access database from TSQL using ADOX.Instead of Access, the Provider can be changed so that it will create *any* kind of database from DBase 3, Oracle, Excel, etc...
2002-12-11
350 reads
This stored procedure takes four parameters1)file to ftp2)server name or IP3)ftp login4)ftp passwordSP will ensure that local file exists before continuing,it will create and execute a batch file in order to push the file to the remote FTP server.--exec exampleEXEC dbo.up_FTPPushFile 'c:\temp\test.txt', 'server', 'user', 'password'
2002-12-09
4,866 reads
By Steve Jones
Leave a gate behind you the way you first found it. – from Excellent...
By SQLPals
Fix Slow, Bloated MSDB: Purge Old History And Add Missing Indexes ...
By James Serra
Organizations increasingly want Snowflake and Microsoft Fabric to coexist without duplicating data or fragmenting...
Comments posted to this topic are about the item 25 Years of SQL Server...
Comments posted to this topic are about the item The Decoded Value
Comments posted to this topic are about the item Deploying SQL Server Developer Edition...
In SQL Server 2025, what is returned from this code:
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(CAST(@message AS VARBINARY(1000))); SELECT BASE64_DECODE(@encoded)See possible answers