Viewing 15 posts - 9,226 through 9,240 (of 9,725 total)
If you back up to disk, a rather simplistic way to do this is to use C# script to list the files in a specific directory that end with your...
December 4, 2007 at 4:22 am
One thing to consider on the SalesTable error is the schema name. Is the default name dbo? If not, you might have to edit whatever query is referencing...
December 4, 2007 at 4:15 am
We get similar error messages at random during the day. We're currently troubleshooting, but our best guess right now is network error. Also, we've gotten that error when...
December 4, 2007 at 4:11 am
I believe the major difference between 32 bit and 64 bit is hardware related. And the only reason you need a different version of SQL for the 64 bit...
December 4, 2007 at 4:09 am
FOUND IT! @=)
Markus (and anyone else looking for this information):
Check out the following links for code to use the Properties->Format->Format Code box of a text box:
Custom formatting: http://msdn2.microsoft.com/en-us/library/7x5bacwt(VS.71).aspx
Standard formatting:...
December 3, 2007 at 12:48 pm
Ah. Unfortunately, I have never done a diagram on MS Visio before so I can't answer your question.
Has anyone else used Visio for diagramming dbs?
December 3, 2007 at 7:48 am
B_Boy,
What software are you using for your diagram? Erwin?
December 3, 2007 at 6:40 am
Absolutely. Well, you can use one to show the primary key & foreign key stuff. Not sure about the other constraints. But I'm pretty sure you can...
December 3, 2007 at 6:25 am
Markus,
What topic did you search in BOL to find the above? I couldn't find it no matter what I tried.
Thanks,
December 3, 2007 at 6:08 am
Thanks, Markus! Worked like a charm. @=)
Is there a weblink or a BOL topic that I can search to see all the different types of format codes one can...
December 3, 2007 at 5:33 am
The first question you should ask of everyone who has access to the server is "What has changed?". This might help you pinpoint the problem faster. I'm assuming...
November 30, 2007 at 4:18 am
Well, gosh darnit! Now I have to go begging up to Corporate (who has outlawed new SQL 2000 installs) and see if they will give me a copy of...
November 29, 2007 at 7:32 am
Microsoft seems to have their documentation mixed up. Here's where I got my information:
Books Online - Index Search - pages [SQL Server], about pages
Page Types:
Data
Data rows with all...
November 29, 2007 at 7:30 am
I have to agree with Timothy. It depends on what your employer of choice is looking for.
I originally used the cert material as a method of learning the basics...
November 29, 2007 at 6:40 am
Viewing 15 posts - 9,226 through 9,240 (of 9,725 total)