You need to separate out each call using the batch terminator GO. So you need:

SELECT ... FROM ...

GO

ALTER TABLE ...

GO

SELECT ... FROM ...

GO

djackson 22568 (3/13/2011)

---

OK, for all those others who seem to have this issue, I was able to figure out what the cause was.

First, one MS article suggested issues with SP2....

You should not have any data in the model database - that is the database the SQL Server uses to build tempdb and as the 'model' for new databases that...

In your code - you are not specifying RECOVERY which tells SQL Server to finish the backup and recover the database.

From the GUI - you need to select the option...

SQLdba-473999 (3/10/2011)

---

Thank you for your response. Since this will occur after hours I believe the DBs in high performance mode should be fine - I'll just watch the log...

Most likely the issue is with the data - but, there is at least one bug that might apply here:

http://support.microsoft.com/kb/958214

Validate the version you are running, and if it is not...

I think it really depends on how large your transaction logs are now, and whether or not you have enough room in them to handle the increased usage.

For example, I...

jligda 35032 (3/7/2011)

---

I just read that SQL 2005 Standard only supports 4 CPUs!

http://www.microsoft.com/sqlserver/2005/en/us/compare-features.aspx

We have two quadcore Xeon e5410 @ 2.33GHz. What happens when you try and run standard 2005...

With this server configuration, I have to assume you either have multiple instances - or you have many more databases in that instance that just this one database.

If this is...

Right-click on the database you want to check and run the Schema Changes History report. Note, this report uses the default trace and will only go back as far...

I don't have any idea about your system - or the indexes that you are rebuilding and how much space is required.

You need to identify how large the indexes are...

Yes - and that is the problem...it might break the log chain, but no way to be sure. So, to be safe - I would not recommend running transaction...

No, NO, NO...

Yes, the transaction log file filled up during that...

There is a very small possibility that you could be in the middle of a transaction log backup - and the drive becomes unavailable just at the right time to...

I would not stop performing transaction log backups and rely solely on database snapshots or even SAN snapshots. First, you cannot restore to a point in time from a...