There ws a time that because of boredness I made a script that make "almost" an exact copy of a table. I mean the schema of a table and later...

Ahhhh ok thanks very much question cleared 😀

Where did you choose "Start"? in the Enterprise Manager? I dunno if this can help but try it anyways who knows maybe this make your server agent starts..

START>SETTING>CONTROL PANEL>ADMINISTRATIVE TOOL>SERVICES>Find...

The 2 databases(version 7) that will be restored in different server is 70 and those databases in the server with ms sql version 2000 is 80 any problem with it?...

Thanks for the info guys 😀

THis is what i did wehn restoring/transferring databases in different server

1. Run List Log-in and Users (version2000) script

- (I think I got this in the script...

you...

Somewhat like sp_help table_name but more straight forward

sp_mshelpcolumns table_name

e.g.

sp_mshelpcolumns 'Data_table'

Sergiy (9/28/2007)

---

Hope you did not miss this statements:

"Updating fields in system tables can prevent an instance of Microsoft® SQL Server™ from running or can cause data loss. "

"On production systems,...

Got this URL in 1 of the old topics here in sqlservercentral

http://www.mssqlserver.com/tsql/

Sometimes UPDATE,DELETE statements are better to be done in TSQL than Enterprise Manager. 1 good example is when you are deleting many rows in a certain table, when you use...

Msg 8115, Level 16, State 6, Line 45

Arithmetic overflow error converting varchar to data type numeric.

I think the problem in that error is not about the datetime but converting from...

Hope this helps a bit

http://www.databasejournal.com/features/mssql/article.php/1477311

http://www.computerperformance.co.uk/SQL2000/SQL_monitor.htm

Ouch :w00t: ok thanks very risky to play with the system tables

philcart (9/25/2007)

---

Lester, probably not a good idea to go around modifying system tables directly. Can get you into an awful pickle with Microsoft when you have a problem you want...