shobana.rajaram (9/18/2008)

---

Hi, id like to be able to update 100000 rows at a time and commit the transaction. Basically what i am trying to do is break a long running...

And, what is the size of tempdb in your production system?

You probably should move tempdb to another drive that has enough space available. Is the disaster recovery system setup...

Scott Ohar (9/18/2008)

---

Service Pack 2 Failed

Product : Database Services (MSSQLSERVER)

Product Version...

That would indicate a priviliges issue - try creating a new job (doesn't have to have anything in it or be scheduled) and see if you get any errors.

The concatenation operator in SQL Server is the plus sign (+). Change your formula to ([STATE_ID] + [COUNT_ID]).

I wouldn't say that - I didn't see it the first time through either. 😀

BTW - with that condition I would be verifying the table for DRI and/or triggers...

Step 1: Import Excel spreadsheet into SQL Server

Step 2: Write update script to use data in imported table

Basic structure of the script would be something like:

BEGIN TRANSACTION;

SELECT * INTO dbo.Report_T_Backup...

Try running the following query:

SELECT ChargeCodeDE, count(*)

FROM Charge_Code_Fee_Schedule

WHERE EffectiveEndDT IS NOT NULL;

For every row that has a count > 1 - you will have a problem. Now, change...

Version 9.0.3054 is service pack two with a small patch to fix some problems with maintenance plans. You can find more information at:

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

This contains a link to the update...

If you cannot see SQL Server Agent, then one of two things comes to mind. Either you are connecting to a SQL Server Express Edition (does not have SQL...

Well, you didn't include the insert portion of the procedure - but I am not sure that is needed in this case.

My guess is that for some Charge Codes -...

What you did was show the version of SQL Server that you were connected to. To see the version for your client tools - click on Help | About.

Version...

Just one note on 'sp_updatestats'. By default, this will update statistics using the default sample rate. If you pass in the parameter @resample = 'RESAMPLE' - then the...

The database file will not become smaller just because you truncated a table within the data file. If you do not have any issues with disk space - I...

Look on this site for Tally table and/or Calendar table. Either of those articles will show you how this can be accomplished.