Sure thing and good luck.

If you remember, let us know what you did and what worked (or didn't).

Steve

Very strange. Is the SQL Server accepting TCP/IP as the protocol? Wonder if it's named pipes, which are limited to local connections.

Other than that, you've slightly stumped me. Can you...

Certificates expire, but over days or weeks. Plus if they expire, then you need to change the encryption on your data.

You should use symmetric encryption on the data and then...

I'll have to see if I can get the developers to answer that. I'll ask them next week. Right not I like them working on other bugs 🙂

The old forums...

This should be fixed.

Sorry it won't be a betting item for the daily office pool, but we'll try to come up with something else.

Frank is back!!!

Don't forget to unsubcribe one account.

As an FYI, Frank's email was different than he remembered. It's not necessarily his fault as I've had the email guys change mine...

That's interesting. I always wondered who used it. For me it's a gauge of how busy things are. But I tend to look for posts that have few replies to...

We're still debating this. We'll explain it more on the pages, and figure out if posts should be in the forums.

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