Why can't you rename a server? I have done it many times.

Wait a minute....

I've installed SQL 2005 a few zillion times and, unless my memory is failing miserably, I do not remember anyplace to enter the company name during installation.

What...

My question is why is the log file so big in the model database?

The first thing I would question would be the Access code.

If the query is running slowly through the VBA, then does it also run as slowly directly in a SSMS...

How about an SMS text, a Blackberry PIN message, and possibly a cell phone call?

Is email the only method that can be used to send notifications for an alert?

With further testing, I discovered that we are both correct.

Yes, I originally changed it through the GUI. In a table this size, that could cause the system to slow...

It seems as if you do not need a function, but an update of the field.

Are you trying to correct some values in a table?

How about

create function test(@Country NVARCHAR(100),@Addressline NVARCHAR(100))

returns nvarchar(100)

AS

Begin

declare @result nvarchar(100)

set @result= (select (SUBSTRING(@ADDRESSLINE, nullif(patindex('% ' + s.format + ' %', ' ' +...

After I though about your statement:

You cannot alter a column to add/remove the identity property. You would have to create a new column completely and then drop the old one.

I...

I stand corrected. It's early, and the caffiene hasn't kicked in.

I still think that leaving the clustered index off will be faster when performing the insert. That being...

How about option 3?

1. Use BCP to copy the data out.

2. Create the new table, without the identity. Leave it as an integer(or a bigint), and do not...

If this is for Dev/QA/sandboxes, then the following code should work for you. It sets the database to simple, and shrinks both the log and data files. ...

Think about what you have, and what you need.

By grouping both fields, you have all of the unique combinations of the category and activity for the date.

You table probably contains...

How about:

SELECT MAX(Datefield) as MostRecentDate, CategoryID

FROM Table

GROUP BY CategoryID

Or, did I miss something?