You need to verify the security permissions on the new 'server'. Most likely, your account does not have the necessary permissions to update the database anymore.

How are you showing the results view? Is that in some application that you have, or is this in SSMS? If this is in SSMS - and you...

I put system databases in their own plan - perform integrity checks every night, backup all system databases (this includes model) and remove old backups older than 1 day (we...

Gail - yeah, I probably should have mentioned that -...

Do you have a value that is the same in both databases that you could use to join? If so, you can use a merge join. Read up...

Are you backing up to a device - or a file? How is this being selected?

What Gail was trying to get at is that overwriting an existing file destroys...

What are you doing now to show the results view? If you write a query in a query window, you can select the columns you want to show and...

The only thing I know of is enabling/disabling the following:

ALLOW_ROW_LOCKS

ALLOW_PAGE_LOCKS

By default, the above options are ON for the indexes. You could try disabling (OFF) the option to ALLOW_PAGE_LOCKS to...

sharanurampur (4/24/2009)

---

Dear Friends,

I too don't know the exact problem, what I am predicting is we are having 2 instances and...

I am not sure - I do know that performing the shrink will force the pages to be re-allocated so there is free space at the end, which is going...

Bob Hovious (4/23/2009)

---

Can someone help out here? I started to answer yet another question about catching output from a procedure which builds dynamic SQL. Jeffrey Williams...

Gift Peddie (4/23/2009)

---

What I found if you are running Standard you can import your DTS packages and create packages similar DTS but nothing more all ETL require the Enterprise edition....

Because you are not using SQL Server 2008 Express - you do not have the option of attaching a user defined database. You have a server running that controls...

What account is running SQL Agent? Does that account have the necessary rights to login to the other systems with Windows Authentication?

Are you sure the job running as an...

Steve Jones - Editor (4/23/2009)

---

The reindex will need space to complete, but it ought to get you a set of contiguous extents. The issue is that you don't know where...