Viewing 15 posts - 1,831 through 1,845 (of 3,221 total)
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...
July 28, 2010 at 12:12 pm
Brandie
Steve Jones - Editor (7/28/2010)
--------------------------------------------------------------------------------
Wait, you can't back up a log in simple mode? Can't I stop the service and just copy the file?
Sure. But before you start the...
July 28, 2010 at 11:09 am
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
July 28, 2010 at 10:42 am
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
July 28, 2010 at 9:45 am
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
July 28, 2010 at 9:21 am
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...
July 28, 2010 at 8:53 am
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...
July 28, 2010 at 7:38 am
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....
July 28, 2010 at 6:48 am
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...
July 27, 2010 at 12:15 pm
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...
July 26, 2010 at 8:42 am
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...
July 25, 2010 at 4:49 pm
Nice question - clear and to the point ..yet it makes one think and learn
Thank you
July 24, 2010 at 7:02 pm
Your expected output:
ID CompanyID CategoryID
CA A CA001
CA A ...
July 24, 2010 at 10:23 am
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...
July 24, 2010 at 9:55 am
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...
July 23, 2010 at 1:54 pm
Viewing 15 posts - 1,831 through 1,845 (of 3,221 total)