SQL Server database programming

Is it possible to see the contents of Extended Stored Procedure? Madhivanan ...

I need to export SQL data to fixed width text file using osql.  Everything works except the following portion which includes a trailing blank that I can't get rid of: select cast(datepart(q, dateadd(q, -1, getdate())) as char(1)) + ...

Hi, I define a field as auto number field, usually how people deal with if data is growing near 2147483647? Thanks. ...

Hi Guys This above error is suppose to be fixed in SP4 for SQL Server 2000, however, SP4 is not available yet! Does anyone know of a HOT FIX or work around? Many Thanks Luke ...

Is there a known performance issue using the aggregate SQL function MAX within a temp table?  I am looking for confirmation that this is/is not a (known) defect within SQL Server 2000.  Or, perhaps this is a SQL Server ...

This one has stumped me! I recently implemented a process to monitor database usage and growth on our production servers.  I use on server as the "master" that collects data from all the other servers into one database.  The ...

SQL 2000: Ack!  I thought my database had ANSI NULLS set to On.  I find that it doesn't.  I always use IS NULL to check for the existence of nulls, rather than using = NULL, so this setting might not matter much. ...