The way I learn is to not only take notes of keypoints while I'm studying, but to have 2005 set up on a test server where I can try the...

Dan,

How are you backing up? T-SQL or with a maintenance plan? Or are you using a third party tool?

Where are you backing up? Tape Drive, disk drive,...

Stupid question, but when you upgraded your software, did you upgrade your hardware too?

I've noticed on some boxes that if the hardware remains at 2000 levels, that 2005 can run...

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