Hello again,

The fact that you mentioned the Application can connect with an Invalid (SQL Server) Username or Password strongly suggests that these are being ignored and instead (Windows) Integrated Security...

Hello again,

That could be true. Can you see the Connection String that the Application is using? I would guess there is an “Integrated Security” Clause in there.

I mentioned Activity Monitor...

Hello,

Is the SQL Server listening on Dynamic Ports? If it is, and as you mentioned a Firewall, it might be best swapping it to a Static Port, and then grant...

Hello,

It would be interesting to find out under what credentials the user is then accessing the SQL Server. Can you open up Activity Manager from with SQL Server Management Studio...

Hello Christophe,

Definitely listen to Florian’s suggestion of using one of the Money Data types, unless you will not be storing Cents, in which case an Integer could be a good...

Hello,

If I understand your question correctly, you just need to include the parameter in your Where clause e.g.

Where FName Like '%' + @name + '%'

Regards,

John Marsh

Hello,

May be take a look at this article:-

http://www.builderau.com.au/program/sqlserver/soa/Script-Table-definitions-using-TSQL/0,339028455,339293405,00.htm

Regards,

John Marsh

Hello,

Please see the Books Online Topic "Modifying Data Through a View".

Regards,

John Marsh

Hello Ryan,

Does the following link describe a similar issue to the one you are experiencing:-

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=286695

Regards,

John Marsh

Hello again,

The Text Data Type is still available in SQL Server 2008. Please see:-

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

Regards,

John Marsh

Hello,

Oddly enough CharIndex seems to work in SQL 2005 for the VarChar(Max) Data Type. I didn’t expect that from the MS documentation.

I am not sure what the efficiency effect would...

Hello,

You could try running through this Troubleshooting guide (if you haven’t already):-

http://blogs.msdn.com/sql_protocols/archive/2008/04/30/steps-to-troubleshoot-connectivity-issues.aspx

Regards,

John Marsh

Hello,

May be take a look at this article. In particular the paragraph “Cross-Database and Cross-Server Dependencies”:-

http://sqlblog.com/blogs/aaron_bertrand/archive/2008/09/09/keeping-sysdepends-up-to-date-in-sql-server-2008.aspx

Regards,

John Marsh

Hello,

Are you using an SP to perform the original Insert? Personally, I would put this Business Logic in the SP rather than a Trigger, where it can be “hidden” when...

Hello,

Possibly write the output to a Table (in your DBA DB) and then extract it at your leisure.

Regards,

John Marsh