Moved to a more appropriate forum.

My guess is either the person building the poster didn't do a great job or the developers did what many people do when they're building a database:

They forget to add...

You can retrieve the image, but it must come out as a stream, not as a part of your result set.

http://www.a1vbcode.com/vbtip-97.asp

Search for ADO Stream.

I'd definitely create new roles that manage the permissions and then be sure you have each login in the correct role that matches permissions from the previous ones.

Sorry I don't...

You must have started it with the -m (or -g) parameter. Check the settings for the service. Or if someone started it from the command line with this switch, shut...

That's an interesting requirement. Why do the names change if the image doesn't? Or does it?

It does pose an interesting problem. How are you sending to the client? Is this...

Logs are automatically reused, but you need to do log backups. Log backups are a part of any SQL Server installation. You can set up the simple recovery mode, which...

Ay, sorry. That is a 2005 thing. For some reason I thought I was in that forum. Sorry 🙁

This works, be very, very careful

sp_configure 'allow updates', 1

go

reconfigure with override

go

update sysxlogins

...

It's a big debate on images in the database. I tend to leave them out so I can easily view/edit them if needed, but lots of people want to keep...

The problem is that subqueries can't return multiple values in some cases. Your data probably violates that. Try one of the suggestions above.

There are some things that "time out" before the autogrow finishes. I think this might be one.

Try to increase the size of the filegroup and see if that helps. I...

Thanks for the comments and glad you like it.

New desk is in a box, should get that set up today, so maybe Friday or Mondays' podcast will have that. I...

I'm not a localization expert, however I've seen that question marks often appear in clients when the local code page doesn't support the character.

I've seen the Word quotes in emails...

ALTER LOGIN should allow you to specify a new name.

With a script, you could drive this for a group of logins. Permissions should be the same.

ALTER LOGIN STEVE

NAME...

Nice link! I'm adding your feed to my Database Weekly list!