SELECT OBJECTPROPERTY(Object_ID('TableName'),'TableHasPrimaryKey')

Or, if you want to check all the tables.

SELECT name, OBJECTPROPERTY(Object_ID,'TableHasPrimaryKey') FROM sys.tables

It's hard to recommend a script to auto-generate primary keys, because the question is, what does the...

Grant Fritchey (1/6/2009)

---

I used to have a 100-sided die. Great novelty, but the stupid thing would roll across the street before it stopped and it was hard to tell which...

Greg Edwards (1/6/2009)

---

At some point, I have to ask the dumb question to Gail :w00t: - the more sides, the more precise the answer? or the more likely to...

Which edition was that? I know...

Please post table definitions and sample data. Read this to see the best way to post this to get quick responses.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

mark (1/6/2009)

---

Or do something sane and calculate the maximum amount of wait time your users are willing to tolerate, determine the amount of space Sql Server can initialize in that...

What compatibility mode is your database in?

Can you get the full message?

Go to the SQL job, open the job step that's failing. On the 'Advanced' page you can enter a file name for the full output...

Maybe for you. 😉 I play D&D. The 20-sided dice is the most important one.

I have 4, 6, 8, 10 and...

Is the database in full recovery?

Do you have regular transaction logs?

Can you do a final log backup before you restore the backup?

shiwani2002sg (1/5/2009)

---

hay all

Well i want relation to be generated on the attribute 'A' of both the tables. but in both table A does not include any keys. and its stated...

I recommend a 20-sided dice.

That's the only way you can do it. Database snapshots are read-only and...

Can you post the execution plan please. Save as a .sqlplan file, zip that and attach it to your post.

But no smaller than necessary. If the index needs to be four columns wide to be useful, making it only...