External Article

SQL Server CREATE TABLE syntax diagrams

  • Article

Many of us have seen, on MSDN, the heading 'Syntax', followed by a rash of nested brackets and keywords, enough to put off the most resolute of code-cutters. However, there is a goldmine of information there, and Phil had an ambition to get at it, and share the gold. The result is this article, full of railroad diagrams.


4,367 reads

Technical Article

RE: Permissions in sql server 2000 (URGENT)

  • Reply

Hi Sheilish,Only once did I need to get around the limitation of this "dco" security scheme regarding identity_insert where I required strict accountability of the sequential identity numbers (for 1 table in 1 application).If you need to do this you can custom code around it as follows.  Unfortunately I don't have a generic solution since […]


Technical Article

RE: Restoring Database Problems

  • Reply

A message box appears to me , only with this...Microsoft SQL-DMO(ODBC SQLState : 42000 )An internal consistency error occcurred. Contact Techinal Support for assistance.Backup and restore operation terminally abnormally.ok button...I tried to restore a backup from disk, but the file was restored from a tape.


Technical Article

RE: T-SQL and Microsoft Query

  • Reply

That message is OK to ignore.  It just means that Query analyzer can't display it in the Query By Example (QBE) area.  The CASE statements are too complex for it to represent.You'll get similar messages if you create UNION queries, and often if you're doing pivot/crosstab type queries.  The query will most likely run ok since […]


4 reads

Technical Article

RE: Problem with Linked Server

  • Reply

Thanks for the link to further details on how to set this up. As it turns out, security on the objects in the Access database were not being enforced. I was able to map to 'Admin' with a NULL password without having to point to the system.mdw file in the registry.CSDunn



Goal Progress for Nov 2022


I set goals at the beginning of the year, and I’m tracking my progress...

PGSQL PHRIDAY #3: What is the PostgreSQL Community To You?


Very excited to take part in my third #PGSQLPhriday blogging event, even more so...

Daily Coping 2 Dec 2022


Today’s coping tip is to enjoy new music today: play, sing, dance, or listen....

Read the latest Blogs


Query with query ID (nnn) is not found in the query store

By MMartin1

Hi: I ran into an issue when I looked to try to manually force...

SQL Saturday MN #1028 on December 3rd, 2022 (Virtual Event)

By Jeff Moden

This event is "tomorrow" on Saturday, December the 3rd. Here's the link for their...

Page 1 or 2 Unavailable

By homebrew01

When on page 1 of a thread, if the latest post is on “Page...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers