Programming SQL

how to retrieve full text of procedure definition from syscomment
Hello, I am trying to locate where/when data is being inserted into a table from a DB I recently inherited. So I write this in QA select * from syscomments where text like '%Insert Into CompareSubscribers%' This will retrieve the procedure(s) that contains the text "...Insert Into..." But when I selec... 22 Feb 2006 12:43

Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0"
This works fine locally and then you move the MDB to the server (Windows 2003/SqlServer 2005) it bombs with the following errors, even though it worked yesterday and nothing that we can think of has changed (except maybe the latest automatic updates) SELECT * FROM OPENDATASOURCE( 'Microsoft.Jet.OL... 21 Feb 2006 22:03

how to suppress namespace?
Hello, I've got a query that dynamically generates an XML schema based on a lookup table. Everything works fine, except that I would like to suppress the generation of the namespace declarations on the individual elements in xml type created by the sub-select. Here's the code: WITH XMLNAMESPACES ('http://tem... 21 Feb 2006 21:32

sqs2005 CASE WHEN THEN
Hey, Substring function doesn't accept a negative length: so in sqlserver2000 we added a case to first check the length, and if it is = 1 then calculate substring. SELECT ALL CASE WHEN -3 >= 1 THEN {fn SUBSTRING('12345', 5, -3)} ELSE '' END In sqs2005 this stmt gives "Invalid length parameter passed to the... 23 Feb 2006 15:54

Database Documentation is important
Hi As a project manager, · Do you have an up-2-date overview of the database structure? · What will you do when your database administrator leaves your company? · Are you willing to pay extra hours to update the database information? As a developer, · Do you spent too much hours on writing boring database ... 20 Feb 2006 17:49

Primarykey Fields
I'm try to get table columns name & primary key to generat Dlete/Insert script to all my database tables.. I was able to get list of all user tables from sysobject and columns list from syscolumns.. Now i need to know the primary key column (For delete Statments).. How could i detrmine which column is primaryke... 20 Feb 2006 04:07

Access ADP integration?
I'm sorry but Management Studio is slow, cumbersome and difficult to quickly make changes while designing a new system. It is directly and very visibly impacting my teams production. The same can be said for developing databases though the Visual Studio IDE. We are at our highest production when using Access AD... 19 Feb 2006 11:37

SQL 2005 T-SQL Reference
I have a book that came with SQL Server 7.0 called the "Microsoft SQL Server Transact-SQL and Utilities Reference, Volume 1." It basically lists the T-SQL statements with common examples for each. Nothing else, no programming techniques, no tutorial, etc. I use it extensively because I've never liked the onscree... 17 Feb 2006 14:25

Timeout expired
I'm having trouble finding the cause of the following error message: [Error#: -2147217871 Description: Timeout expired (Source: Microsoft OLE DB Provider for SQL Server)] The error is occuring when trying to execute a simple update query: UPDATE merchant_billing SET billing_last_billing_date = '2/15/2006' WH... 17 Feb 2006 09:11

Key column is insufficient or incorrect. too many rows were affect
Hi, When I open table, return all rows using Enterprise Manager and I tried to edit a column, it returned "Key column is insufficient or incorrect. too many rows were affected by update" This is a standalone table. No constraint. No formula. Advice please. TIA ! ... 16 Feb 2006 03:55