How are you doing the import?

It installs off of the same disk provided you select it as an option and you first have IIS installed on your machine.

What makes you think that the SoundExe value is derived from the CompanyName? What does the SoundExe values represent?

Uh, unless I don't quite understand your question, this is just a simple update statement.

DECLARE @Commission_Soundex TABLE (

[SoundID] [int] IDENTITY (1,...

Yes, please do. I'd be interested in reading that if you find it.

Thanks Lynn!

Why use a temp table and incur the overhead??

create table a (clientid int, Unitbalance numeric(21,0),Dates datetime)

set nocount on

insert into a values (123, 999, '20080101')

insert into a values (456, 888,...

Why not have the process that runs every 5 seconds (ouch) run by a sysadmin user and then simply grant read access to the table to the users that need...

These guys have you on the right track here. You definately don't need a cursor or loop to do this. If you need additional help with this, please...

Unless someone comes up with a fancy workaround, you should not be able to do this. Once you've restored or attached a SQL Server 2000 DB to a SQL...

How much of the total size of your DB do you expect to be removing? It is worth seconding Noel's post. You've stated that you have 2 GB...

Also, your WHERE clause of PO.PODescription LIKE '%00000%' will normally produce a table scan. It's a bit hard to say for sure though as you have not posted an...

So you're asking for help tuning a query containing joins and you post a sample query with only the SELECT clause? How in the world are we supposed to...

Are there any 'ALTER TABLE' statements within the triggers?

Here's another: http://www.eggheadcafe.com/forumarchives/SQLServerprogramming/Jan2006/post26057430.asp

What is your trigger doing?

This may help http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=816590&SiteID=17&pageid=0