You will need some scripting to identify the file and change the package to import it. Check http://www.sqldts.com for some ideas.

Also, please post in the appropriate forum.

The big one is probably being sure indexes are ok and statistics are up to date.

I think this is still being debated and I'd be comfortable with either approach as long as it was documented well. The call from the script package means you have...

Shrink the files, and then be sure that you are backing up the log periodically. A database backup is not enough.

Don't cross post

http://www.sqlservercentral.com/Forums/Topic436148-5-1.aspx

The error log will display percentage of recovery if it's moving slowly. It is possible you have some redo or undo action that eats up log space. What was happening...

Dont' cross post.

Handled here: http://www.sqlservercentral.com/Forums/Topic436125-357-1.aspx

Right click, properties, remove the dbouse only option

If you need a result, send it back from the SP. A proc with an update statement doesn't generate a result set.

you can force one

create proc myproc

as

begin

update xx set yyy...

First, the 4 part naming convention is server.database.schema.object. The prefixes are everything before the object.

Second, I'd recommend that you create a view in one database pointing to the other object....

This is a windows issue, not a SQL issue. SQL takes it's time from the windows system.

Look up time servers. You should have a server on your network that acts...

HAVING is used with aggregates. I'm not sure what you mean. Are you saying something like

select *

from mytable

where ID = (select count(*) 'cnt'

...

In addition to above advice:

- Index primary keys and foreign keys.

- Do not assume the primary key needs to be clustered. Look at the queries that you...

If you are talking about the code behind built in XPs, this is code at Microsoft that they are not releasing. Or I haven't seen released. The XP is a...

I definitely agree with you on SSMS. I tend to use QA unless I need to see an existing object. I like quick, lightweight stuff.

Jim,

you are correct and if I...