Viewing 15 posts - 76 through 90 (of 102 total)
Latin1_General_CI_AS is the Prefered Coallation for SQL2000 I think the install gets it it from the Windows Coalltion settings. SQL_Latin1_General_Cp1_CI_AS is for backward compatability. Latin1_General_CI_AS is probably your server coallation.
You could...
March 23, 2004 at 6:30 am
Erm.. Is there a learge difference in Data size.
Our developement DB's have minimal data. We only use similar size DB's on Test DB's
March 23, 2004 at 4:28 am
Is your MSSQL sevice running?
I know I know.
March 23, 2004 at 4:16 am
Password is Binary in 2000 - Varchar in 6.5
March 12, 2004 at 3:37 am
Thanks Jeff - I've tried it and due to Different Schema etc it's not working. It's a day of typing for my I fear
March 11, 2004 at 10:02 am
Amit you're a genius!
That sounds the business. Thank you very much.
March 9, 2004 at 2:29 am
I am thinking of granting a user access to EM so they can use DTS to generate ad hoc queries and copy data to access/excel. DTS was the recommendation beacause...
March 5, 2004 at 3:28 am
You don't have to create a backup device.. Just create your db with new devices, then right click and select backup restore.Go to the restore tab and click on "from...
February 27, 2004 at 2:26 am
When I double click on 'Servername' I get hex on the left of the window that pops up, but over on the top right I can see 'Servername', underneath that...
January 19, 2004 at 3:28 am
You just double click on the machine name. Scroll down and it will be on the right hand side
January 19, 2004 at 2:26 am
That sound like a superb idea. Although if it is actually written on the PC as opposed to on a post-it are you open to being hacked???
I'm going back to...
January 16, 2004 at 9:24 am
For 6.5 run regedit - Go to HKEY_CURRENT_USER/Software/microsoft/MSSQLserver/SQLEW/Registered servers and then double click on the required one.
THe SA will be on the right of the screen vertically.
Don't tell anyone this...
January 16, 2004 at 3:47 am
Hey Eamon this sript was on this site a few weeks ago. I've used it a number of times and it worked quite well.
CREATE view sysFKeys as
select...
December 19, 2003 at 3:16 am
It mean "Yes I have a bit of Irish/Gaelic" - Eoin is pronounced like O - N .
Tschus.
November 26, 2003 at 6:12 am
Viewing 15 posts - 76 through 90 (of 102 total)