Grant rights to a role
This Stored procedure is used for granting rights to a particular role. user has to just Pass Role Name as argument.It will assign Right on User Table and Stored Procedures.
2003-02-27
159 reads
Scripts
Quick and Dirty Server/Instance information
I do a lot of SQL Server Desktop Edition instance testing and I cobbled together this script from BOL and other scripts I've seen posted. It is intended to show version, service pack level, machine and instance name and the security type among other information. Hopefully someone else may find it of use.
2003-02-27
278 reads
Generate Insert/Update/Delete Sprocs for a table
A week ago I posted this script. It was a much simpeler version without error checking. Now all the sprocs return the same errors. 0 THERE WERE NO ERRORS -99 UNEXPECTED NR OF RECORDS AFFECTED 0 THE SQL ERROR NUMBER Also with the insert statement the @ID is set. So you can retrieve the […]
2003-02-25
423 reads
Send Message to All Users
A procedure send message to all active SQL Server users(SQL Server Connections) on your Server.I use Win command NET SEND.
2003-02-25
557 reads
A Simple way to find the line of script.
You can use this procedure to find any word or sentance, which u used in procedures, views, triggers and function. This procedure is basically a modified form of system procedure "sp_helptext". Now its upto you to use that and modified that. To execute the procedure, first create it in your Database and then execute it […]
2003-02-24
170 reads
Files MaxSize
A Procedure send Alert by E-Mail about allfiles with option "Restrict File Growth" ifavailable space less then 10%.
2003-02-24
359 reads
Func. generates insert and select for large table
Generates an insert statement including column list. Useful for identity table data copying. Just modify the code generated to select and insert the needed fields. Saves time on large table inserts (also generates a select statement. Use part or all of the SQL generated. Saves development time when dealing with large tables.
2003-02-21
217 reads
Gen. vars, types and select into vars for a table
Generates a declare statement including data types for a table and generates a select statement to set the variables from the table. Speeds development time when dealing with getting values into variable from large tables.
2003-02-21
168 reads
Find Duplicate Indexes (Updated)
This script returns the Duplicate indexes on any database (if any). Compatible with SQL Server 2000 only. Latest update Checks for possible duplications and removes them. Further, additional fields are displayed to support decision making.
2003-02-20
1,196 reads
LOG OVERSIZE Report for all DB
When log_file bigger then data_file you will getReport by E-Mail.For ALL DB.
2003-02-20
193 reads
Blogs
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Forums
Alamat BCA KCP Bursa Efek Jakarta Tlp:0821°7555°651
Tlp/Wa 62 8217555651 Gd. Bursa Efek Jakarta, Jl. Jend. Sudirman kav 52-53 Tower II...
Alamat BCA KCP WTC Sudirman Telp:0821.8200.233
Telp/Wa 62 8218200233 World Trade Center I, Jl. Jenderal Sudirman No.Kav. 29, RT.8/RW.3, Kuningan,...
BCA KCP Sampoerna Strategic Square Telp:08218200203
Telp/Wa 62 8218200203 Gd. Sampoerna Strategic Square, Jl. Jenderal Sudirman Tower A - Ground...