Glad to help. As with all things, practice makes perfect.

This code snippet might work for you.

create table #tbl (imagefile varchar(50), location varchar(50))

declare @filename varchar(50)

, @sql varchar(255)

insert into #tbl (imagefile, location) values ('C:\Images\0\1.tif', 'backup')

insert into #tbl (imagefile, location)...

You could also create views in the current db that union tables across dbs (assuming they have the same structure).

create view1

as

select * from db1.dbo.tblname

union

select * from db2.dbo.tblname

This might be causing your problem

FROM BOL (DBCC SHRINKFILE):

If target_size is specified, DBCC SHRINKFILE attempts to shrink the file to the specified size. Used pages in the part of the...

Use the fully qualified name in your FROM clause: [dbname].[owner].[tblname]

I've unfortunately had to do this a number of times against a legacy db I inherited.

I usually start off by checking for occurrences in the syscomments table and then wade...

I would just schedule a job executing xp_cmdshell.

Functional always trumps elegance!

Try replacing

SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES

with this

SELECT TABLE_SCHEMA + '.' + TABLE_NAME FROM INFORMATION_SCHEMA.TABLES

Server role dbcreator grants a user the ability to create, alter, and drop databases. This would give them access to modify any database on the server.

Database roles db_owner and db_ddladmin...

Sergiy (8/25/2008)

---

Reindexing of clustered index changes order of pages for all other indexes on the same table.

So, clustered indexes must be processed first. I don't see where your script takes...

If you're interested, here's a script we run over the weekend (downtime) to identify and defrag indexes. It uses extent switching and logical scan fragmentation as the defrag indicators.

Comments are...

You could add a LIKE filter on the TextData column for %insert% and %update%.

The job runs under the account that started the SQL Server Agent service. Make sure that that account has adequate rights to run the DTS and has access to the...

Working from your example, something like this might work:

declare @col1 int, @col2 int, @col3 int

declare @tbl table (col1 int, col2 int, col3 int)

insert into @tbl values (1, 0, 0)

insert into...