Contents tagged with SQL Server
-
Who Owns Your Databases?
Right now we have owners set to whoever creates the databases for most databases, but there are a few owned by sa. I'm thinking how great it would be to consolidate this. To this end, I've created a database owner domain account and added it as a SQL server login. The login only has the public server role. In a move common with things I typically do, going overboard, I have denied this accounts ability to connect to the server and disabled it.
-
SQL + XML(?) + Unicode = Issue
The title of this post may not be entirely accurate, but it is pretty close. I recently encountered an issue with a 3rd party component that was reading unicode information from a MSSQL 2005 database and then sending an email using the value. For some reason, what appeared to be random unicode characters from SQL were displayed as the flattened '?'. The odd thing was the they were right next to other unicode values that came through just fine. Very odd...
-
SQL Server - Print MAX
Welcome to my blog, this is post numero uno. I would like to thank Joe Stagner for hooking me up with a blog on weblogs.asp.net. My name is Bennett Dill and I am an Application Architect at a market research firm in Cincinnati Ohio. I have been programming for about ten years starting with ASP Classic and VB 6 right on up to C# and ASP.NET. I don't know if I'm going to be a good blogger, but I'll give it a whirl.