Hi

How are you going to migrate your users. I think you will have to script all your logins and users and create them in the server that you are moving...

Hi

Better read through the basics of SQL. That may be just what you want in this case.

Hi

I dont have a script or vb code or anything simply becoz i have never been in a position that you find yourself in.

What you could do is

Loop through...

Hi

There are lots of articles on the web regarding table partitioning sepcially the one by KimberTripp.

http://msdn2.microsoft.com/en-us/library/ms345146.aspx

Dont know whether this is what you require and I dont know too much about...

From BOL

"The algorithm for calculating fragmentation is more precise in SQL Server 2005 than in SQL Server 2000. As a result, the fragmentation values will appear higher. "

Would'nt it be possible for you run the change scripts in your test environment or would that be time consuming. That way your test data can be preserved.

Hi

you will have to write a utility that connects to each server

and within connects to each db to check for the tables existence.

a doubt..

You will be executing this utility...

Hi

Are the keywords higlighted in the management studio. I had this problem with keywords not being highlighted in management studio .

Hi

10000 records is not that high a number.do the inserts occur as a batch. can u be more specific as to what you want to do. Generally calling procedures from...

Hi

3 ways that i can think of now are

1) Use SSIS

2) IN mgmt studio - select Query\Results\ResultstoText and then copy paste the output to a textfile.

3) IN mgmt...

Hi

It would be better if you learn some basic things of SQL server. It would help you and us to co-operate better.

And nothing beats doing things ourselves.

Hi

Seems ur SQL is configured to listen to a particular port. In this case you will have to sepcify the port to connect to the SQL Instance. Or you can...

hi

Whats the error that u r getting. did u check the error log for details.

Hi

one more thing never use master database or any other system databases.

Hi

You can use information_schema.table_constraints.