Gulappa Vijaya Kumar

User-defined data type dependencies

MSSQLServer has got sp_depends system sp to display the dependencies for a stored procedure, table and view.  sp_depends does not support to display the User-defined data type dependencies.  For custom database, we will create user defined data types (UDDT) and add this UDDT to a column/variable in a table/stored procedure.  This sp (UDTDepends) will help […]

5 (1)

2003-10-30

437 reads

Stabilize Index

This sp is used to update index in a database.  This sp has got three optional varchar parameters.  First parameter will take the tablename. Second parameter will take the indexname.  Third parameter will take the fillfactor.  The following option we can execute the sp in a user database.1.    exec StabilizeIndexIt will update all index in […]

1 (1)

2003-10-29

272 reads

Blogs

Interview with Greg Low

By

This is the sixth interview we have done. This time our guest is Greg...

Azure SQL Database Types

By

I want to do a quick summary post of the many different types of...

Azure SQL Database – Azure Portal Updates

By

A small but useful change has been made to the Azure Portal for Data...

Read the latest Blogs

Forums

Is Data the Future of the Vibrant Web?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Data the Future of...

Users cannot run/view a report, but can all the other reports. How?

By Rod at work

I've got a problem which I can't figure out. I've got 3 SSRS reports,...

Find the Originating DB Name, Not the Current DB Name

By fahey.jonathan

I am considering creating a "Tools" (or similar name) database to hold common procedures...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers