I second the motion on SQLPing. I've never had it fail in my enterprise of 130+ SQL Servers. It's slower because it uses several methods of finding a...

Here's a link to a great article about what happens with blanks:

http://www.sqlservercentral.com/articles/T-SQL/63953/

An alternative to what George posted is at: http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx

This site includes not just major builds but build numbers including different patches and hotfixes.

Instead of doing a LEN on your data, try doing a DATALENGTH. You can get an accurate count of bytes used that way.

Personally, I use scripting as often as possible, for several reasons. One is that it gives me total control over the process and two, I do it so I...

If they have a tool that can search my entire 65,000+ table PeopleSoft database in mere seconds I want to see that.

Seriously, how can their product be faster than a...

I'm unimpressed. I wrote a simple TSQL script to search for text strings across all tables in a database and it took a lot less than a week.

This is...

Thank you so much that in this world of liberal political "correctness" that someone still has the stones to say Merry Christmas!

God bless you and yours, Steve,

Chris

Even though you say it's scheduled make sure the schedule is enabled too.

It looks like Windows SUS isn't flagging any of my servers unless they have Reporting Services installed. We don't use Microsoft Update on our servers.

FWIW, the component that's being...

You could do something like this:

Select 'Name' As myColumn1, 'Address' As myColumn2

Union

Select myColumn1, myColumn2

From myTable

Where blah, blah

Basically the first query is just doing a SELECT of all the column names...

Yes, you can add a linked server to an MSDE instance. If you are unable to manage the MSDE instance you can always link TO the MSDE instance from...

Select myColumns

Into myServer.myDatabase.myOwner.myTable

From myTable

It's pretty much as simple as that, other than any security you may have to be aware of that may prohibit this.

I believe for SQL 2005 and better you're always going to get DISABLED back from that query.

Licensing isn't embedded in SQL or the registry anymore. You need to keep...