Just to make sure I am not insane, I took one of our dev boxes, renamed the MACHINE from Dev001 to Dev010, re-added it to Active Directory, and used sp_dropserver...

This is what you said in a previous post. Were you referring...

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. ...