NOt sure I understood your question completely put this will return all table names and associated schemas.

SELECT SCHEMA_NAME(schema_id) + '.' + Name FROM sys.objects WHERE type_desc = 'USER_TABLE'

Using Nortwind db...

Brandie

Sure. But before you start the...

Using BOL check the following:

i. SQL Server 2005 Books Online (September 2007)

sp_dbcmptlevel (Transact-SQL) or

http://technet.microsoft.com/en-us/library/ms178653(SQL.90).aspx

2. Backward Compatibility

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/8c69df2a-02e7-4665-a3ee-4f038f50b4ac.htm

Are the OPs getting bummer and dumber or just lazy and lazier, have others noticed this behavior with fellow workers?

http://www.sqlservercentral.com/Forums/Topic960056-146-1.aspx?Update=1

Go to

http://technet.microsoft.com/en-us/default.aspx

Input "Upgrading to SQL Server 2008" .. you will presented with a list/links to 41,400 articles / blog posting /BOL pages etc. READ THEM

Try this

CREATE TABLE QTest(PR VARCHAR(MAX))

INSERT INTO QTEST

SELECT 'SELECT SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE [dbo].[SP1]

SELECT * FROM ORDER'

SELECT PR FROM Qtest (Displaying in text format using SSMS) gives:

SELECT SET...

stchambers

This may not directly address your problem however read this blog posting by LynnPettis - which contains code for all sorts of date time manipulations. You may want...

Ken@Work

You will be more likely to receive a tested answer by:

1. Posting you last question to a new forum

Including the table structure as you have in your last posting

2....

You will increase your chances for someone posting a tested solution if you posted the table definition(s) and some sample data (NOT actual data, but something reasonably close) as described...

webrunner

Easy enough to find out ...

CREATE TABLE #T(userid INT)

INSERT INTO #T

SELECT 1 UNION ALL

SELECT 1 UNION ALL

SELECT 2 UNION ALL

SELECT 3 UNION ALL

SELECT 4 UNION ALL

SELECT 5 UNION...

As a beginning read the following article:

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

Here is an extremely brief abstract of the granularity of tasks::

Also, SQL Server 2008 allows granular definition of audit criteria. Audits can be scoped...

Nice question - clear and to the point ..yet it makes one think and learn

Thank you

Your expected output:

ID CompanyID CategoryID

CA A CA001

CA A ...

What do you have .... do you have SQL Server Express or another version of SQL 2005?

If you have SQL 2005 express installed with default location then run the program...

Transfer all the data and then TRUNCATE the table

From TRUNCATE TABLE in Books On Line

If the table contains an identity column, the counter for that column is reset to the...