Just a addition to this you should always set a inital size for temp db so it will not auto grow again n again.

Yeah it will be better if you modify the code what gail has suggested or you need to delete the rows one-by-one.

Hi All,

I'm getting below error when I'm trying to open an existing package in business development studio.

make sure the application for the project type (.dtproj) is installed

And getting below error...

Hi All,

I'm getting below error when I'm trying to open an existing package in business development studio.

make sure the application for the project type (.dtproj) is installed

And getting below error...

As the title you've written as "Different Domain" I don't think you can do it so easily. Before doing anything did u tried to connect the 2nd server from 1st...

lmu92 (6/29/2009)

---

Hi Rohit,

It looks like you've misunderstood the concept of this site... We're not "free-of-charge-online-code-generators"!

The purpose of...

lmu92 (6/29/2009)

---

Hi Rohit,

It looks like you've misunderstood the concept of this site... We're not "free-of-charge-online-code-generators"!

The purpose of...

Gordo (6/25/2009)

---

I don't know what the point is in having a primary key constraint on an identity column though (what would you gain from this?). Perhaps SQL Server is...

You query will delete all the files with 'txt' extension.

But errorlog files don't have any extension. It's sumthing like...

ERRORLOG (Current log file)

ERRORLOG.1

ERRORLOG.2

ERRORLOG.3

.........

So 'xp_delete_file' will run successfully without deleting anything.

Hope this...

This might be helpful

http://social.msdn.microsoft.com/forums/en-US/sqldatabasemirroring/thread/0b55e80d-4b07-4f21-a703-756c2d40c484/

Ram

Hi Lorenzo,

There is no straight forward answer to this as But below are some point which you might need to look at.

Do you have...

1). Many operations being done with out...

Hello Paresh,

How you doing the backups?

Through a maintenance plan or sql job. First thing I'll suggest you is go with SQL JOB and follow the below steps.

If you are...

Yes you can generate scripts for all the stored procedures and function through generate script option.

I think if you are able to export the data from this table (which I...

if possible can you post the sample code as to understand what exactly you are trying to do?

Whenever a db is in suspect mode then the first thing you need to check the reason as why the db is in suspect mode, and you can easily find...