It is very easy to get caught up in trying to come up with a perfect spec, but it is rarely worth the time since you are running a virtual...

You probably know this but it is servername\instance not / (you wrote / twice so maybe thats the problem?).

Have you tried servername,portnumber instead of servername\instance?

This will extract only users from selected database. Got it here at sqlservercentral, can't remember who though.

USE DATABASE

GO

select'CREATE LOGIN ' + sl.name +

' WITH PASSWORD = ' + sys.fn_varbintohexstr(sl.password_hash)...

Hi,

I've inherited priority boost a number of times (im a consultant) and every time the DBA/Techie that turned that option on

did it without knowing what it does. "It sounded...

Same link to the kb that I posted above.

Primary key maybe.

Something that helps you identify the row.

You could also narrow down the problem if above isn't working for you.

Select column from xx

where column between 1 and 100.

if...

Did you restore over an existing database without using the overwrite flag?

Basically you have to identify the rows that contain the invalid value and update them with a valid value.

Have a look at:

Troubleshooting DBCC error 2570 in SQL Server 2005 and...

Right on, all the things you described sounds right.

I run everything in vmware, if you have a very good set up regarding storage/com/vmware you are good to go.

Off course you...

Abu Dina.

How about INIT or using diffrent filenames for each backup =)

Hi,

Use management studio (2008), connect to your 2000 instance, expand sql agent, right click on a job, Script job as>Create to> File or new query editor window.

Use the generated code...

Google.com - Search for:

SQL Server 2008 setup100.exe and setuppatch.exe cannot be run in this mode

There is a lot of info about this.

Sorry I cant.

If I have any problems I always turn to Quest, they got all the info and support you would need.

Log in to quest, they probably have a kb for the issue.

Nice!