It's a sad truth that it doesn't matter if your users are athenticated or not. Don't go the 5 seat route. If you get caught, you could get...

I hate to break it to you, dr_csharp, but all SQL Server 2005 have some limitations on what OS they will use. At minimum, any Windows 2000 OS has...

We actually have a T-SQL script which uses XPCmdShell to read a list of the backup files from a specific directory. Then we parse the name down to pull...

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...

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...

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...

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...

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:...

B_Boy,

I use Erwin by Computer Associates.

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?

B_Boy,

What software are you using for your diagram? Erwin?

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...

Markus,

What topic did you search in BOL to find the above? I couldn't find it no matter what I tried.

Thanks,

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...

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...