Great article and scripts, thanks!

Steve,

Thanks for fixing the question.

I think this article is a great start, but it ends too early, just using ALTER DATABASE only changes the default collation, it doesn't change existing tables, columns, or the...

I too selected the wrong "correct" answer because I assumed you wouldn't choose to use the deprecated version, when there is a current fully supported version that works on all...

You can see more specs on the new HP drives on page 11 of this: http://h20000.www2.hp.com/bc/docs/support/SupportManual/c01071496/c01071496.pdf

The sequential numbers don't look as good, but the random numbers are fairly similar.

Thanks for posting the suggestion, I think that would be great and have voted for it.

This sounds like you app is looking in the current folder for it's INI file to get the server and DB name, and not the folder of the EXE. (I...

I have looked and done some research, but haven't gotten anyting to try yet.

You might look at what HP offers: http://h20000.www2.hp.com/bc/docs/support/SupportManual/c01580706/c01580706.pdf

It looks like they are going to have some good...

Thanks for the question. And I am glad that MS finally added backup compression to the standard edition.

In other words try:

SELECT *

FROM [MYSqlSLAVE]..[DB_Name].[Table_Name]

Years later and the question is still broken... 😉

Have you checked the sys.dm_exec_connections view to see if you connect via a different method by name than by IP? (Maybe by name uses named pipes while by IP address...

Make sure that "WORKGROUP\myhostname$" has access to everything it needs. (I'm not sure if a myhostname$ account can access network resources.) Otherwise you might want to create a SQL Agent...

I am not aware of any way to make it send an XLS file. You can however tell it to use TAB as a delimiter and make the extension .CSV...

MiguelSQL (3/11/2011)

---

SOLVE IT.

It is a problem with the domain trust.

So I created a local account, login using the LOCAL account, and was able to start SQL on single mode and...