Hi Jason,

Am looking for answer for below two questions

1. How the logins got automatically mapped? How sid(s) got Mapped? Normally, we use auto_fix/update_one as parameters to sp_change_users_login.

2. Do...

Thank You All.

Changing the database owner to sa solved the "dbo" user problem

USE database

EXEC sp_changedbowner 'sa'

GO

True!

I will split the script into small parts which gives us more control.

Thank You.

Here one of the sql statement which is taking more time.

ALTER TABLE TNAME ALTER COLUMN VERSIONID CHAR(10);

Table contains 4 crore data in it.

It took me 40 minutes to execute the...

Hi guys,

I have got an important point to figure out here. It is taking hell out of time.

I stopped the script execution.

I found few front end applications are being...

Came to know that the scope a variable is a batch not the loop or anything else.

Hope this helps!

Basically, both the databases are involved in the replication.

There are some common table which are being replicated from a different database from a different sql server/instance.

yes. the 60 GB database is also resides on the same instance.

Thanks All,

i have used the format file. it worked out.

9.0

3

1 SQLCHAR 0 ...

Hi Adi,

I have observed while one the developer came to me that why the table variable is not getting

deallocated when it is declared inside a WHILE loop. at any...

Hey,

Am using SQL 2000 and that is the reason why am going for a windows batch file.

Thanks Muthu:-)

Found by my self.

REFERENCES permission means that a user who is the owner of table A can define a foreign key on table B, which she does not own, if...

Thanks All.