I guess you are using sql server 2005 with sp 2 , please install sp4 in which this issue is sightly resolved with max rows, but the best part to...

Direct upgradation of sql 200 to 2008 or 2008 R2 is not pssible, first you have to upgare to 2005 and then to 2008.

Thanks all for your time.

I would like to see what does it call internally in dbcc pintable

Hi

I have some basic thing to say here, please correct me if i am wrong.

firstly while refreshing the database the process is

1) Backup the DB and then copy...

you might have given the user more permissions thn required , thats the reason you are able to execute the store proc,

please check the permissions at the server level as...

since both user names and pwds are same,

if all the above things doesnt work, then simply drop the user from the newly created DB and recreate the user with...

there is some clarity missing here,

1) do you want your sp1 to run only after the sp2 is completed:- for this you can schedule a job with two steps

Or

2)...

Hi all,

I have instance of sql servers up and running and I am able ping the server but not able to connect it. how can I resolve this issue?

"how did...

If it is the job happening for the backup, then directly go to the jop properties and see in the edit step tab, the path where the backup is going.

Not a recommended idea, but you can also do this!

export that single table into a sample DB (just created for this purpose)

and then backup that DB , by this way...

i didnt understand your atatement here , that one machine is in the domain and the other on inst,

my guess:-

one database (publisher ) in in the domain and the (subcriber)...

Check the job histroie and the shared location for the backups

this will find the trouble area,

can u plz elobrate ur requirements.:hehe:

I have a doubt here????????????????????

Sql Server does't allow you to dalete your own login when you are logged into the server.

then how come all this Magic happened.

if you were using...