David, I appreciate the candor and articulation of the process that you went through. I realize that writing/formatting/proofreading the article was probably just as time consuming as writing the...

So let me get this right. You're suggesting Password123 be my duress password instead of password123? Yah, I think that might work!

I think there are...

Solomon, you know I'm already a fan, but wow!! I agree with Phil, this article is completely unique across the internet. Anybody considering SQL CLR development should start...

Love these types of tips!! Keep em coming.

Now I just gotta close the 200 query windows I have loaded and upgrade SQL Prompt :hehe:

Personally, I think that SQL Server (set based RDBMS) is a fairly focused product. Yes, SQL in all its flavors is a language, but it have a specific purpose....

I think Phil's thoughts and concerns are spot on. The specific knowledge required to code, secure, test, optimize, deploy, maintain, and document SQL CLR functionality between SQL devs, system...

I use CLR extensively, and while it may be possible to kludge some convoluted solutions together to accomplish the same thing, if coded correctly, and used appropriately, it makes code...

I solved this issue by using the SQL# (www.sqlsharp.com) library. The Date_FormatTimeSpan function (which is part of the free functionality) is very flexible. For example, here are 3...

Thank you. I had read that article and was hoping I wouldn't have to create another 11 filegroups/files and move and then remove. I guess I didn't realize...

Jim, excellent thought. I had created a function to script out the create and drop indexes for a table, and I should have just used that idea instead...would make...

No, the server is SQL 2008.

The script works fine (the auditing works fine) if I execute the scripts through SSMS.

The objects get created if I execute them via the batch...

SQL 2008 Enterprise

You're right, I was creating the indexes WITH (ONLINE = ON).

After looking at some research and my situation, I think I'll eliminate the ONLINE attribute.

Thanks!

I too am having issues trying to connect a 64 bit (x64) SQL Server 2005 to Teradata.

Has anybody had any luck?

I did get the 64 bit OLE DB for ODBC...

I haven't played with SQL 2008 yet. Does anybody know if anything along these lines has been introduced in SQL 2008?

If not, almost makes me want to start sending...