waiting for help.....not yet resolved......has anyone done replication and then a SQL compare.....what do you guys get?

Is there any database property I need to set or put off?

SELECT @@VERSION will give you all the details of the version and the name of the product you are using......to know other you can use Select serverproperty( ).......checkout the property...

Help.....Help.Help.......

I have cross checked the database settings for ANSI_WARNINGS, ANSI_NULLS,ANSI_PADDINGS and others, but they are same for both the databases, and are set to OFF..........still the difference.....can you tell me...

Someone please help.....this is critical.....if you want any other additional information to solve this, please ask......

did you specify the ip address of the server in the connection string of the application? This might be silly but worth asking.....;)

You can have a select query with case of substring(status,bit no,1) to have the same result.............

Can you provide us the following details -

1> r u using a network drive or a tape drive to save?

2> have you saved it as your backup device?

3> does the...

Try creating a new job and then editing it or viewing its properties........

Do you have sufficient rights to perform the action.........in few cases, you will be able to create new jobs and edit those and others for which you have rights ;).......

Right-click on the job and select Properties.............:D

I am going to try this feature already integrated with SQL Server 2008.....it is not long before we upgrade.....and wait for the next one....hehehehe....

Use the following script in SQL 2005 to check for orphaned users -

SELECT UserName = name

FROM sysusers

WHERE issqluser = 1

AND sid is not null

AND sid <> 0x0

AND suser_sname(sid) is null

ORDER...

....and in SQL 2005 the sys.syslogins provide all the informations in columns.....so no probs.....

I agree with Sopheap........maximum server uptime is always the primary duty of a DBA.....:)