I would be hesitant to try the following since there is the potential to do quite a bit of damage but I thought I might mention you could use the...

You can use the following to get the data from sysfiles in each db into a temp table.

If the databases are attached their files will be locked (mdf, ndf, ldf)...

Once you load your excel data to a table you can join it to your "real" table and do an update.

Sounds like this is a one time thing so it...

Oops, Michael added his post before I refreshed. That's what happens when work gets in the way of forum posting! 😀

You might want to use a Lookup transform.

Instead of putting the logic into a case statement you can create a table with MyValue and MyOutput columns. Then run the output...

On the destination do you have "Table or View - fast load" selected, along with a table lock? If you are inserting into a heap table you should be able...

Are you trying to find out if a table has IDENTITY_INSERT set to ON?

You might try Openrowset (Bulk...)

http://blogs.msdn.com/sqlserverstorageengine/archive/2006/05/30/Preprocessing-data-before-bulk-import.aspx

-- insert into YourTable (ColA, ColB)

SELECT

ColA

,CASE WHEN LEN(ColB) > 0 THEN ColB ELSE NULL END AS ColB

FROM OPENROWSET

(BULK

\\UNC\YourFile.txt

,FORMATFILE = \\UNC\FormatFile.fmt

) as...

If your job dependencies are all linear, Job 1 then 2 then 3, you could add sp_start_job as the last step of jobs 1 and 2 to call 2 and...

The Project Real documents have a lot of good content:

http://www.microsoft.com/sqlserver/2005/en/us/project-real.aspx

Just want to make sure I understand the question. The data that your lookup transformation is using has more than one matching row based on the join columns in the...

SQL 2005 has database diagramming functionality, check books online for “database diagramming”. It’s not as full featured as what you would see in Erwin or ER/Studio but it’s free.

Visio can...

Did ALZDBA’s post from the other forum give you the result you wanted?

Same code below but with the distinct removed, will eliminate nulls and what you have left is count...

WITH CTE_Keys -- ID just the PKs and FKs from info_schema.key col usage

AS

(

SELECT

k.CONSTRAINT_NAME

,k.TABLE_SCHEMA

,k.TABLE_NAME

,k.COLUMN_NAME

,o.[type]

,o.type_desc

FROM

INFORMATION_SCHEMA.KEY_COLUMN_USAGE k

INNER JOIN sys.objects o

ON OBJECT_ID(k.CONSTRAINT_NAME) = o.[object_id]

AND o.[type] IN (...

You will also want to look for permissions inherited through database role membership.

Users who have been added to built in database roles like db_datareader and db_datawriter will have permissions...