I can speak for the databases. Use detach, copy the files then attach. There are a few special considerations when doing this for the master, model, msdb and tempdb databases....

The easy answer is daily (master, model, msdb in one maintenance plan) keeping 3 days online (our site standard). To be more precise (minimalist) for those tight on disk space:

model...

Right now we're looking at an entire forrest. We need to get to a grove of trees in the forrest. What indexes are on the tables ? Are there primary...

I'd be interested as well.

The code snippet above that uses xp_cmdshell is a common tool. I've used it for years for a variety of things. Just a couple of things to remember about it....

This is not really an error, more of an informational message. Your stored procedure was created. The message you refer to just means that the stored procedure sp_depends (which shows you dependencies...

Since you are in the process of 'standardizing' you probably want the same information for all databases on a given server. sysfiles exists in all databases and contains the file...

Just to find out when things were created maybe something like:

select name, crdate from sysobjects

where name like 'IX_%ID%'

order by crdate desc

Not pretty or slick code. Just maybe what you...

Select count(*) from TABLENAME where IMAGECOLUMNNAME IS Null

The front end might not always be responsible ... here's a workaround, by no means elegant ...

create table name_info (

 lname varchar(16) null,

 fname varchar(16) null,

 mname varchar(16) null,

)

go

insert into name_info values ('first','middle','last')

go

select...

Just a minor clarification on 'global' temp tables. If it is truly global (i.e ## as stated) and not in a transaction, anyone may drop it. Just take query analyzer...

If it's a stored procedure and all activites are in one database only, then try removing 3 part (dbname.dbo.table) names from the procedure and using one part names (table) then...

If the table allows NULL for the image then:

drop table t

go

create table t (c1 int, i1 image null)

go

insert into t values (1,'111')

go

insert into t values (2,NULL)

go

select * from t

go

select c1...

How are you executing these scripts ? e.g. each in a separate DOS window ? I've done this in the past and on large tables I've noticed that script 1-10...

Have you looked in the SQL Server errorlog file ? (C:\Program Files\Microsoft SQL Server\MSSQL\LOG\errorlog --> default installatino, default instance). The System and Application event logs are next. Then, if you...