There's a lot of Javascripting here, so I'm not surprised with that.

Can you let us know what you did? Might help others.

Send the old and new ones to webmaster and we'll look at it.

Get rid of the function.

declare @dt datetime

select @dt = dateadd( d, -365, getdate())

update

...

and entrydate < @dt

That gets you a scalar. It's possible that you can't get this to run better...

Change the login with the SQL Configuration Manager. It will assign the correct permissions.

As Andrew mentioned, you need one of these:

insert into Table_1

SELECT b.last_name,

b.first_name,

b.City

, null

OR

insert into Table_1 (last_name, first_name, city)

SELECT b.last_name,

b.first_name,

b.City

I don't believe encryption is time based. I could be missing something, but that's not how I understand the SQL Server 2005 encryption.

How is encryption set up? Is it symmetric,...

Are you sure that SQL Server accepts Mixed mode connections? Just double check and be sure your IPs are correct. I've had people change them and someone else doesn't realize...

Here's a few options:

http://blogs.msdn.com/tudortr/archive/2005/11/03/488731.aspx

http://msdn2.microsoft.com/en-us/library/ms159272.aspx

It's on the list, but it's a lower priority.

Search now limits by forum, but still won't help with what you are looking for.

Chris,

Do you mean a new reply? I agree that the front page doesn't do a great job , but I'm not sure the old one showed replies at the top...

Jason,

I think you have a good plan for now. Look at them on disk as well (defrag there) and then go with your plan.

Filters Added today!

We'll work on search over time and see what we can come up with.

Steve

:), note the access rights and then remove them. It's the easiest way to see if someone's using the table.

Or you can set up a trace for access to certain...

Don't set a lot of alerts. Let them track things and have some metrics ready on what you track. Too many things spike for minutes, like CPU, to alert on....