The SQL Server server collation determines that. However, to change it isn't a quick thing:

Setting and Changing the Server Collation (SQL Server 2005 Books Online)

But that's, to use a cliche, throwing the baby out with the bath water. For that 1% who are abusive, the first time, put 'em on notice. Make it very...

I would instantiate only one trace. The logon trigger can see if a trace is running (or you could write to a semaphore table or something) and if so, it...

Profiler actually uses a trace file locally. If you watch the %temp% directory, you can see it created as Profiler starts up. Not sure how it writes the file locally,...

When you check SQL Server Configuration Manager, is the TCP/IP protocol enabled? If so, is the SQL Browser service running? If so, note the port for TCP/IP, if you connect...

And to put it back to BBS era (I was a SysOp for Wildcat!, Spitfire, and T.A.G. as well as a doors and door utility [think conversion of the various...

IMing is great for short, quick asynch communications. Especially when folks are working on several things or are away from their desk. When it used to be allowed where I...

True. I think I'm just going to write a script to extract the info. A royal pain, but it seems necessary.

Actually, this is a good way to do it. Here is a code sample from the presentation I gave at SQL Saturday Jacksonville. And it's actually a Logon Trigger (showed...

Okay, so the connection is failing. Check the password you're using in the app.

Is the login failed happening for all stored procedures or just that one?

I don't know how twitter brings in money. I know that for me it allows an interaction similar to IM. For me it isn't about self promotion. Among the folks...

No, they haven't. The scripting options are pretty much the same.

It's by object. You can right-click on the database and choose Tasks | Generate Scripts. When you get to the Script Options screen, you'll need to set Script Object-Level Permissions...

Is anything else successfully connecting to the instance? If so, did the BUILTIN\Administrators group get removed?