I got this script from this site and it works fantastic. I would just like to give an update to this script. All credit should go to the person that published this script on this site not me. I would just like to point out a few things. If you want to schedule this as […]
2002-10-18
442 reads
Have seen existing scripts to work out number of days in month. They tend to work out the month, and then whether it's a leap year.Another approach is to take the date passed in, find the first day of the next month, and then use Datadd to take off one day, ie: last day of […]
2002-10-17
455 reads
How many times have you seen @@version return a number but failed to interpret what service pack it is? Although SQL 2000 gives a gift (SERVERPROPERTY) of querying a readable value, my script will remedy the puzzle and show more parameters such as CPU speed, memory, windows version, and installation date. The limitations are:1. MSDE […]
2002-10-16
468 reads
This SP will only work on SQL Server 2000 and can be placed in your master database. sp_CreateAndExecTableScript is designed to script one table and create an identical table. I designed it to use with DTS packages so that I can create an identical table with a different name, pump data into the table and […]
2002-10-15
2,561 reads
Fixed user protion of the script. Sorry had the test script mixed with prod. I was asked to create a report listing all of our SQL Servers, and the databases on them. I was also asked to list everyone that has access to each database and whether it was a standard, windows or windows group […]
2002-10-15
1,068 reads
The script allows you to prepare an xml document as you would use the sp_xml_preparedocument but by specifying a SQL statement. i.esp_xml_preparedocumentfromcolumn @iDoc OUTPUT, 'SELECT TOP 1 documentColumn From myTable'
2002-10-12
586 reads
A user defined function to return a table af tokens from a delimited string.Uses text variable so string can be of unlimited length, performs better than a list of xml elements. Now supports returning of tokens by position
2002-10-12
818 reads
This script will create a standard format file for a specified table for use with bcp or Bulk Insert.
2002-10-09
1,407 reads
I wanted to be able to prepare a script of User Roles and permissions for objects in a database so I can be prepared for backup and disaster recovery scenarios. I also wanted to be able to audit the permissions for each role.I wrote this stored procedure to do this. The usage is:Use NorthwindgoDECLARE @RC […]
2002-10-09
963 reads
I have wriiten this Procedure which Drop all primary keysin whole database Dynamically. Create This Procedure in any User database . Execute it . It Will drop all Primary KeysEnjoy
2002-10-09
310 reads
A RAG pipeline that answers questions in the demo is not the same thing...
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Telp/WA 62 821-8200-203 Menara Bidakara, Jl. Gatot Subroto No.Kav.71-73 Lt. Lobby dan Lt. 1,...
Telp/WA 62 821-8200-233 Jl. Melawai Raya No.Blok B, RT.7/RW.5, Kramat Pela, Kec. Kby. Baru,...
Telp/WA 62 821-8200-174 Wisma BCA Pd. Indah, Jl. Metro Pondok Indah No.10, RT.3/RW.17, Pd....
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers