RE: Creating a PDF from a Stored Procedure

I agree about the comments and I'll take the blame - I load the content, should have gotten it cleaned up. I'll try to do better! Andy http://qa.sqlservercentral.com/columnists/awarren/

Which is not a way to change your...

Using sp_addalias

SP_addalias isn't a well known stored procedure to most DBA's - do you know what it does? In what situations you might use it? This short article gives very quick and clean answers to both of those questions.

Due to a new security initiative at Incompetent...

Where would you find the output of a...

RE: A problem with MDAC version 2.8

I am definitly sure, that I havn't a network error or SQL server error. When I was rollbacked MDAC to version 2.71.9030, this store procedure worked without problem. The same error occurs when I have tested Windows 2003 server and I used it as workstation. When I have run Query Analyzer and have connected with […]

RE: Need Help With Error::

see if this link helps: http://support.microsoft.com/default.aspx?scid=kb;en-us;811028

RE: Query to get first number

quote: Gee, that's a lot of budgets. You, know, the IDENTITY field was designed for this. It would be a LOT faster, easier, and simpler to use the tools that were designed for the job instead of re-invent the wheel. The max size limit of INT is over 2 trillion, so I don't think you're […]

RE: Trigger search for table

If you want the name of the table along with the trigger name: select tbl.name as TABLE_NAME, trg.name as TRIGGER_NAME from sysobjects trg inner join syscomments sc on sc.id = trg.id inner join sysobjects tbl on tbl.id = trg.parent_obj where trg.xtype = 'TR' and sc.text like '%[^A-Z0-9_]sales[^A-Z0-9_]%'

RE: Error 18452

No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!