I'm pretty sure SSMS reads from the Windows Registry when it gets the local instance names. Would that be easier?

It's under HKEY_LOCAL_MACHINE.SOFTWARE.Microsoft.Microsoft SQL Server.Instance Name.SQL.

I seem to remember that...

There probably is a way to query a View's definition in MySQL, similar to querying various metadata objects in SQL Server, but you're probably going to have better luck finding...

Use the Generate Scripts option in Management Studio to script all your objects, including schema names. Use search-and-replace to replace the schema name with a different schema name, run...

Should be possible. All they'd have to do is download a free copy of Management Studio Express, and connect to the server using Windows authentication.

Any particular reason this has to be done via stored procedures? SSIS would be easier.

SSIS can be faster at certain actions inside SQL Server. For example, I have a process that copies data from one server to another on a scheduled basis. ...

It depends on what you want to do with the data. If it's a straight table-to-table copy, with the same structures, then this should be quite easy to do.

You...

If it's been through a proper QA and testing phase, and is part of an automated deployment process from properly configured and used source control, then it shouldn't actually need...

I review the code and deploy it, or send it back for refactoring if it doesn't pass review.

You can automate RedGate's Compare and Data Compare products to do that kind of thing for you, if I'm not mistaken.

SSIS can also merge data changes for you, and you...

jfogel (3/21/2012)

---

It should also be noted that this can cut both ways. Many times when a developer is asking questions of a DBA applicant they will not ask Administration based...

One of the key advantages of using scripts to update table definitions, is that the GUI will do what's been described here, and that can take a long time or...

That's per-design.

If you need sequential numbers for users, have that done in the presentation layer of the application, or at least in the query (using Row_Number, most likely). Don't...

If it literally has "domain\domain user", then that's probably the problem right there.

Otherwise, it's either not finding the specific group/account, or having trouble connecting the the specified domain server.

Hugo Kornelis (3/21/2012)

---

Yes, as GSquared already shows.

However, there are (as far as I...