I don't think you can generate a script from either the database or the objects from T-SQL. SMO has an method to support this, and you can right click a...

Delete the 50 in the script you don't need. Or figure out how you determine which 150 you need. There isn't a script that can read your mind to determine...

You need to read up on this. It's really something that's not easily explained in detail. However the connection strings that are used by clients can determine how the client...

http://msdn.microsoft.com/en-us/library/ms177862.aspx

It depends on how users connect to the computer.

If you are not sure, then change both.

If you click the "Training" menu to the left, we have some online classes.

The different between an Oracle DBA and a SQL Server DBA is the software they work...

The Windows computer name is resolved with NETBIOS on the Windows network. You cannot have two computers with the same name, so Windows prevents this.

DNS is a name lookup service,...

No hurry on any of these.

In terms of today's QotD, I've added a comment. I've never considered running T-SQL in the Query Editor in SSMS to be "using SSMS".

However I can see the confusion.

Alvin Ramard (12/3/2010)

---

I have a confession to make.

While setting up WordPress yesterday, I had to create a MySQL database.

I hope y'all will forgive me. 😛

Hope everyone is having a...

Thanks

Be good to have one in Powershell, and while we're at it, anyone want SQLAzure?

I didn't changed any answers, just marked them as correct, so it probably still shows the old percentages. Not sure what I want to do here, since I don't want...

I wouldn't consider running T-SQL to be using SSMS. I know it technically does because there is no other editor, but I have felt when talking with people over the...

You are welcome. The change was small, and a deployment occurred today.