Viewing 15 posts - 20,341 through 20,355 (of 26,490 total)
jeffrey yao (6/22/2009)
Lynn Pettis (6/22/2009)
A unique key is a candidate key for being a primary key, so Michael Valentine Jones still stands as accurate.
I guess this argument is meaningless. We...
June 22, 2009 at 4:39 pm
You won't find it under tables, you will find it under System Views.
June 22, 2009 at 4:18 pm
Run this: select name, log_reuse_wait_desc from sys.databases
June 22, 2009 at 4:16 pm
jeffrey yao (6/22/2009)
Michael Valentine Jones (6/22/2009)
jeffrey yao (6/22/2009)
I think "no primary keys, no constraints of any kind, no indexes, all columns were nullable, and dates were stored in varchar(8) instead...
June 22, 2009 at 4:00 pm
And we have another one who can't seem to read.
June 22, 2009 at 3:56 pm
nscott (6/22/2009)
I am trying to insert 489 records in Access from one linked SQL 2005 table to another and get the following message:
[ODBC--insert on a linked table 'dbo_WKORDER' failed.
[Microsoft][ODBC SQL...
June 22, 2009 at 3:53 pm
Run this query:
select * from sys.event_notifications
June 22, 2009 at 3:15 pm
What is happening on the network during that time? Any network backups, large data transfers between systems, heavy user activity? Anything that may cause a delay on the...
June 22, 2009 at 12:11 pm
rob.patterson (6/22/2009)
Lynn Pettis (6/22/2009)
Sorry, but according to BOL (Books Online) that information is not stored in metadata.
Yeah, I saw that in BOL also. But it HAS to be stored...
June 22, 2009 at 11:54 am
Sorry, but according to BOL (Books Online) that information is not stored in metadata.
June 22, 2009 at 11:38 am
It could be an intermittent network issue. The best thing to do is actually perform all your backups to a local directory and then move (or copy) the backup...
June 22, 2009 at 11:32 am
unknown (6/22/2009)
http://www.dbasupport.com/
Echo...
This site was mentioned earlier in the thread...
June 22, 2009 at 11:22 am
NEI, Not Enough Information. At this point, please read the first article I have referenced below regarding asking for assistance. Without knowing the table definitions and how the...
June 22, 2009 at 11:19 am
I don't know what is going on here, but for some reason I can't post my code directly in this thread.
Attached is the code I put together for your problem....
June 22, 2009 at 11:14 am
Is Order the name of a column in the table? If so, put brackets around it, like this:
tablealias.[Order] -- Please note, I didn't use yout table name, short term...
June 22, 2009 at 10:47 am
Viewing 15 posts - 20,341 through 20,355 (of 26,490 total)