This is a followup to the script submitted by srallapalli. One can return a record set of all tables in a database using the following:USE MyDatabaseSELECT so.name AS TableName, sc.name AS ColumnName, st.name AS ColumnDatatype, convert(int, sc.length) AS ColumnLength FROM syscolumns sc, sysobjects so , systypes st WHERE so.type='U' AND OBJECTPROPERTY(so.id,'ismsshipped') = 0 AND sc.id=so.id […]
2003-05-10
158 reads
In instances where you have over 16 data files, or you need to move data files to a new location when you are moving a database you must use a CREATE...FOR ATTACH statement. This script will generate the CREATE...FOR ATTACH statement dynamically given a database name. It will take into consideration the file sizes, growths […]
2003-05-07
246 reads
For each user database rebuild indexes, update statistics and shrink. The script will use the system catalog to produce a list of databases. If you want to excluce a database add the excluded db name to the 'not in' list. You can also adjust the target fillfactor.
2003-05-07
1,869 reads
This set of procedures allow you to control simultaneous access to any resource you are using. It mimics the behaviour of a Semaphore in programming.A typical problem where you need this, is when you have a computational intensive procedure you only want to be started a limited number of times.First, add a record to the […]
2003-05-07
294 reads
This script enables you to return data from SQL Server's table without specyfing the name of the column .All you only need to supply is the column number, that you want the data from. In the example we want to chose all rows from the second column (categories table - northwind) Column number is based […]
2003-05-07
179 reads
For each user database remove all the freespace and truncate the transaction log. The script will use the system catalog to produce a list of databases. If you want to excluce a database add the excluded db name to the 'not in' list below.
2003-05-07
1,572 reads
This SP take 0 or 1 parameters. Execute without any parms and you will the sp_attach_db statements for all db's on you server. Execute with a database name and it will generate statements for stated db.
2003-05-06
1,021 reads
I used to list from sysobjects to get this information, but found the INFORMATION_SCHEMA is a lot easier.
2003-05-05
178 reads
Not long ago I was in a forum discussion when someone presented another way to get the date with time value of midnight by doing similar to thisDATEADD(dd,DATEDIFF(dd,0,@DATE),0)Which I find is much cleaner than any other option I have seen or tried myself. Seeing this I realized there are many other dates that can be […]
2003-05-02
497 reads
This procedure will give you the list of tables in the current database along with total columns in the table, no. of rows and the primary key(s) defined for the table.Mohit NayyarMCP, MCAD (.Net), MCSD, MCDBA
2003-04-30
775 reads
By Steve Jones
Thanks to everyone for attending my talk today at Day of data Baton Rouge...
Here’s the scenario: one of my SQL Server instances migrated to the DR array....
By Steve Jones
We are product focused at Redgate Software. Here is another of our values that...
Hub Cs:08218200203 Jl. Yos Sudarso Pantai No.08, Karang Rejo, Kec. Tarakan Bar., Kota Tarakan,...
Hub.Via,WhatsApp:08218200203 Jl. Jenderal Sudirman No.139, Klandasan Ilir, Kec. Balikpapan Kota, Kota Balikpapan, Kalimantan Timur...
Hub.Via,WhatsApp:08218200203 Jl. Jend. A. Yani No.47, Langkai, Kec. Pahandut, Kota Palangka Raya, Kalimantan Tengah...
In SQL Server 2025, I run this code:
select bit_count(-1)What is returned? See possible answers