1. That's fine.

2. sp_helpdb

3. Don't shrink your database. If you need more space, add it. Are you performing regular maintentance on your indexes?

John

Enclose the column name in square brackets ([]).

John

Ashkan

You need to rebuild and/or reorganise your indexes regularly, so if you remove it from this maintenance plan then you should make sure you're doing it somewhere else.

I'm sorry but...

So you have a database at least one of whose tables is gigabytes in size, and you also have a maintenance plan that attempts to shrink the database when it...

http://www.lmgtfy.com/?q=execute+sql+task+result+set+into+variable

Have a look at this, and post back if there's anything you still don't understand.

John

What is your result? Is it a result set or just a scalar value?

John

Something like this will generate a script for you to run and create the tables and copy the data across. You'll want to tweak it a bit so that...

Win

Since you're getting Logon to server 'REDMOND\XXXX' failed, I would guess that your SQL Server Agent doesn't have permission to log on. Have a look under Logins, and check...

Rohit

You're right - they...

Your thinking is indeed correct.

We use sa or the SQL Server Agent account as the job owner. We usually go for the former because it's easier to remember. ...

Nithi

You still haven't specified what you need help with.

Let's look at your stored procedure, though. It looks unnecessarily complicated. Why do you not just insert straight from the...

Nithi

Please will you be more specific about what sort of help you're looking for? A good place to start would be if you posted your stored procedure definition.

John

Wardy

In that case, put all your file names in a table and use a For Each Loop task to loop through them.

John

Wardy

If you only have ten categories then it's probably worth setting up ten separate file connections and ten separate dataflow tasks. If you don't want to do that, then...

Vamsy

Since the operations you mention are fully logged, I would say that doing one of them on the source database would also do it on the target. That's just...