I don't believe you can upgrade the instance. You can install Developer Edition as another instance or you can detach your databases, uninstall Express, and then install Developer.

All upgrades or...

Haven't tried it from the 2.0 wizard, but an insert should be an insert. Check the table, look for triggers, be sure you're inserting the proper data types in the...

Why do you need this during production hours? You should have enough space free in your database to last for some period of time, a month, 6, a year, something....

I assume you're run the uninstall and deleted registry keys.

Did the cluster get uninstalled from Windows or just SQL Server?

Sorry you're having a bad day. Get some coffee.

If you rebuild your indexes, then it should update the count in sysindexes.

For transferring data, use a consistent method, and I'd select using a query from QA.

I think your boss does not understand how a log works. It's not like a log file written by IIS. It's a circular file that's used to record the transactions...

There isn't any reason to delay things in SQL Server. The app can submit stuff to SQL Server, to a stored procedure for processing as quickly as it can. Then...

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

...