Scripts

Technical Article

Bulk Insert proc to try out ur optimization skills

This SP can be used for bulk inserting data from an ascii text file onto a table. You have to change the structure, of the temporary table (ITEM_MASTER_TEMP) and the actual table onto which data is inserted, to suit ur needs . I wish you people workout this SP and try to optimize it as […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2004-08-26 (first published: )

228 reads

Technical Article

Find strings in text of stored procedures

Ussualy this kind of scripts queries sysobjects and syscomments like this:select distinct object_name(O.id)from syscomments as Cjoin sysobjects as O on O.id = C.id and o.type = 'P' -- search string only in stored procedureswhere C.text like '%insert into MyTable%'When the text of stored procedures, triggers, functions is over 4000 characters, it is saved in syscomments […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2004-08-26

281 reads

Technical Article

Foreign keys chain in a view. It may be useful.

I made this view because I had to generate a sql server database from  an Oracle database and I had to knew the order in which I import tables.This view, which may be improved, contains the foreign key, the primary and detail table, the column and it's position and may be useful in  many situations

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2004-08-25 (first published: )

135 reads

Technical Article

Search for a string in a procedure, trigger or fun

This is an extension of two previous scripts, this one will produce a list of ojects that contain the first parameter and not the second. The function works as a table so if the user wants to list only functions, query as: select * from fn_sys_searchobject('text1','text2') where object_type = 'function'

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2004-08-19 (first published: )

135 reads

Blogs

Flyway Tips: More Object History

By

I wrote about Flyway Desktop Object History in a previous tip. This feature has...

Why Ai Agents need an eval framework

By

AgentDBA (the database agent I have been building) has more than 1000 automated tests,...

A New Word: Semaphorism

By

semaphorism – n. a conversational hint that you have something personal to say on...

Read the latest Blogs

Forums

Kantor Resmi BCA KCU GALAXY Telp:0821°7555°651

By layanan_Bca88

Telp/WA 628217555651 Jl. Dr. Ir. H. Soekarno No.37-39, Klampis Ngasem, Kec. Sukolilo, Surabaya, Jawa...

Kantor Resmi BCA KCU KEDIRI Telp:0817°82°5533

By m4rt1n4

Telp/WA 62817825533 Jl. Brawijaya No.8, Pocanan, Kec. Kota, Kota Kediri, Jawa Timur 64123

Server-level Roles

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Server-level Roles

Visit the forum

Question of the Day

Server-level Roles

In SQL Server 2025, can I alter a fixed server role?

See possible answers