Is there a question here?

Everything you need to know has already been posted here - you just need to do a bit of reading. To summarise:

(1) Create a clustered index on all tables...

ashish.kuriyal (8/19/2010)

---

instead of shrinking your database regularly, you must redefine your full and log backup schedule.

You will definately see the difference.

if it still growing, then you need to find...

I won't go into why you shouldn't shrink your database - you can search this site and you'll find plenty of references. If you must do it, do it...

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...