I have also done this in T-SQL generators. It can make things simpler to have an expectation of a WHERE clause on every query.

I like how the OP re-stated the same non-question. Perhaps it should have been in bold the second time.

Dugi - your query looks for tables without an entry in key_constraints - so a heap with no constraints will appear. However, you can have key constraints without an...

Sure, but try this:

[font="Courier New"]CREATE TABLE MyTable (ID INT)

GO

CREATE CLUSTERED INDEX idxMyTable_CL_ID ON MyTable(ID)

GO

CREATE NONCLUSTERED INDEX idxMyTable_ID ON MyTable(ID)

GO

SELECT c.name, b.name

FROM sys.tables b

INNER JOIN sys.schemas c ON b.schema_id...

Have to give Lowell some credit in his attempt to figure out what the question might be.

We could start a game show - someone mumbles something related to a question...

And another great forum "question"...

http://www.sqlservercentral.com/Forums/Topic633285-149-1.aspx?

Do you have a question, or is this just a statement?

Grant Fritchey (1/9/2009)

---

Here in New England... it's a New England winter only a little more so. We could use a bit of global warming. There's about 3 inches of completely...

Dugi (1/9/2009)

---

Use this Script to find the Tables without any Primary Keys or Clustered Indexes!

SELECT c.name, b.name

FROM sys.tables b

INNER JOIN sys.schemas c ON b.schema_id = c.schema_id

WHERE b.type...

Probably best posted in a C# forum.

If EOF and BOF are both true, you have a dataset with no rows.

In BIDS, when you created the cube you had to create at least one dsv (data source view) that is basically a collection of queries against your data source(s) and...

You have to use individual logins for your linked server. You can make two logins on ServerB and from the GUI for the linked server, you can map users...

That old join syntax you are using (table names separated by commas in the FROM and the join fields in the WHERE) is really old. Switch to the new...

First, here are some tips for posting. Most people don't like to have to write all of the insert scripts to generate test data - spend the time to...

Binary large object data would typically end up in an image, text or ntext field. varchar(max) and nvarchar(max) are also capable of holding large amounts of data. For...