Guys this is funni,

I thought Obama will be bringing big time change. I voted for him. The very first thing i expected him to do is stop outsourcing or...

Doc,

I need to know this myself how can you stop companies from outsourcing. IBM recently fired 5000 US employees this thursday and hired 5000 in INDIA.

I think if...

yes for me it works fine. 1 job on primary and 2 jobs on secondary.

ok when you setup jobs. do they run fine like does any of these jobs...

Try not to run snapshot agent. I never do since it takes lots of resources. Alternatively

I backup and restore database to make them in synch .

once in synch i setup...

lowell script is fine you just need to introduce conditional clause in case other ppl are inserting at the same time you are inserting.

select * from master..syslogins

Hi ,

when u say wizard. what you mena by that . i setup like this.

right click database--> properties---->Transaction log shipping --> fill up banks there.

did you created shared folder on...

try ping from your machine.

just a stupid idea but make sure your id is in sql server.

you can try one thing. try connecting osql from your machine

dbcc opentran will tell for oldest open transaction.

look for last_batch and status

then runn dbcc inputbuffer(spid)

to see whats it running.

use sp_who2

activity monitor is slow. look for block by for any blocking

32 bit driver for oracel and syabse would not work here. if you are replicating data to or from other platform.

memeoy configuration and drivers if you are usiing linked server. there are seperate drives for 64 bit. other than that it should not give trouble

make sure you are updating stastistics. make sure no indexes were dropped by mistake or reindex table that involve.

you cna also run priler to check at what step its...

what port. are you mentioning port number in connection string.

also try this. instead of server name uset this

ipaddress,port number

or

instance name,port number.

make sure you setup port static many...

weired. why you want to restore tempdb. was you put critical user data in it???