Have a look at Gails blog about "Catch All Queries" here:

http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

This actually becomes one of my standard links 😀

Greets

Flo

Hi Hans

No double click. Click on the register and drag it over the Object Explorer. You will see a little cross in the middle of the Object Explorer. Drop the...

Hi

Question:

Why do you use ADODB instead of ADO.NET?

Could you please wrap your code with the following exception handler and post the result. Maybe this helps to find the problem:

...

I use SSMS2k8 exactly as you described. You have to click the register of Registered Servers and move it up since you see a splitter in the middle of Object...

Ramesh (5/19/2009)

Ya, I know CLR rocks with file handling, string manipulations etc., but I never really liked those .NET languages, 'cause I never...

Ramesh (5/19/2009)

:hehe:And I am hoping that Active-X should die with T-SQL.

I never was...

Hi Ramesh

:w00t:

... I really hope Active-X will die with CLR integration.

Greets

Flo

Hi

I would say it depends.

In maintenance scripts I think it is a "best practice", SSE does the conversion and the overhead should be okay.

In procedures and functions you should use...

Hi

Which exception do you get? Inner and outer exception.

Greets

Flo

Hi

Your question is very general. Here some good sources:

MSDN

http://msdn.microsoft.com/en-us/library/bb545450.aspx

MSDN Tutorials

http://msdn.microsoft.com/en-us/library/ms167593.aspx

SSC

http://www.sqlservercentral.com

SSC Articles

http://www.sqlservercentral.com/Articles/

SSC Training

http://www.sqlservercentral.com/Training/

SQL Tream

http://www.sqlteam.com/

Greets

Flo

Thanks a bunch!

Lynn Pettis (5/18/2009)

Florian Reischl (5/18/2009)

No problem :-). Take the time you need or give me a...

No problem :-). Take the time you need or give me a short hint if you...

Try this:

Select DATALENGTH(FirstName), CONVERT(VARBINARY(MAX), FirstName) From Person

If DATALENGTH returns zero there is nothing within your column, otherwise the second column shows the binary data.

Greets

Flo

I don't think it's possible to use variables in DDL statements. You have use a dynamic SQL statement.