Viewing 15 posts - 9,211 through 9,225 (of 9,715 total)
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,...
December 4, 2007 at 4:48 am
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...
December 4, 2007 at 4:45 am
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...
December 4, 2007 at 4:42 am
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...
December 4, 2007 at 4:35 am
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...
December 4, 2007 at 4:26 am
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
Viewing 15 posts - 9,211 through 9,225 (of 9,715 total)