by AEgir Sveinsso » Sat, 26 Jan 2002 20:39:52
E.g. I discovered that suser_name() should be replaced with suser_sname()
and I wonder if there are other things I need to do.
Thanks,
AEgir Sveinsson
by Andrew J. Kell » Sat, 26 Jan 2002 22:03:43
Check out the section titled "Technical Resources" and you will see
sub-topics that will have info that your after.
--
Andrew J. Kelly, SQL Server MVP
TargitInteractive
Please join me at PASS North America in Denver - the first and only user
conference dedicated to SQL Server.
http://www.sqlpass.org/events/denverjan/index.cfm
Quote:> Does anyone know where I can find somthing on how to tune querys and
> procedures after making this upgrade?
> E.g. I discovered that suser_name() should be replaced with suser_sname()
> and I wonder if there are other things I need to do.
> Thanks,
> AEgir Sveinsson
1. SQL Upgrade Wizard 6.5 to 2000 fails -- HELP!!
I get an error stating on an NT server box:
"Neither DSN nor SERVER keyword supplied. Invalid connection string
attribute"
And this msg comes up next:
Please make sure this value is not NULL."
computer is identical.
The error seems to come up after providing the 'sa' passwords and
selecting the export server. The status box says "Restarting
MSSQLserver service" when the error occurs.
I have tried to reinstall 2000.
I cannot figure this out or find any information on it.
PLEASE HELP!!!
4. upgrade sqlserver 6.5 to 2000 hangs during preparing sql-dmo
5. Job fails
7. How do I kill a process without shutting down the server?
9. procedure on how to upgrade from 6.5 to 2000
11. Upgrading from 6.5 to 2000