Also make sure that your IIS services are started, not just installed.

-Luke.

You definately do not need another license. It's included with the SQL server license.

Are you sure that you have IIS installed? it would not be by default on...

If I remember correctly log shipping wouldn't really work so well for this circumstance as you'd need to keep the remote db in the restoring state for log shipping to...

I'm guessing you've already tried a reboot? If not, perhaps there is something leftover from the initial install that was hung up pending a reboot.

You have no...

If you really want to use Select into, You could drop your table and recreate it with Select INTO and then add the appropriate indexes. You can schedule this...

I'm guessing since you're posting here that this is an access front end with SQL backend?

why not create a form that when they click new(perhaps it opens a new form...

Why not just create an After Insert trigger directly on the table. Why even deal with Service Broker?

http://msdn.microsoft.com/en-us/library/aa258254(SQL.80).aspx

-Luke.

You definately can have 2 tables on the same page... I actually have a report that has 10 or so tables in the same page.

You could do this...

Is it truly available during those busy times? I'd suggest trying to figure out exactly what is causing your performance issues as it seems that the server may be...

Which one did you run first? Perhaps the faster one is the second one and most of the data as well as the execution plan are already cached in...

What happens when "the db's broke" and you can't run a log backup? Say for instance if you lose a disk controller, or disks or a fire engulfs your...

Nice Article Gail, I did have one question though. Perhaps it's just me but it's been something I've seen here at SSC a few times in recent months...

what was...

Removing the dups would probably be a good idea as that x number rows less you have to deal with. You could even do something like a Select Distinct...

you may have some better luck if you remove the derived tables. If I remember correctly, when using a derived table as you are in your join statement in...

current_date and sysdate are not functions in SQL server. are you porting this code from another platform, or are those udf's or CLR functions or something else? This...