Oeps,

I just realized that you posted that in the SQL 2000 discussion. But marking the proc as system object will solve your problem.

Markus

The behaviour of user defined stroed procedures starting with the sp_ prefix has changed in SQL 2005. In SQL 2000 they behaved exactly like a system stored procedure, which means...

James,

I did work on a project where they intended to migrate to whole datacenter to ESX server on HP64 blades and a HP SAN. After extensive testing we had to...

As far as I know, Microsoft doesn't support either windows nor SQL server on VMware only MS Virtual Server.

At least about a year ago that's what they told us. But...

I can't think of any way using T-SQL which achieves exactly what you want. If you have SQL 2005, the fuzzy lookup transformation in SSIS should deliver what you want....

Pepe,

there can be lots of different reasons why your plan fails, but since the consistency check is one of the failing steps I would start with running DBCC CHECKDB from a...

Shelley,

it works for me. Could you post the ddl and your insert procedures. Do you get an error? Which service pack level do you have?

Markus

I'm a susbscriber for more than 4 years and I must say it's one of the best sites I visit. The layout is simple and clear and don't need any...

No, you can't register a 2005 server in EM. You can though connect from Query Analyzer to a 2005 instance, but some (new) functionality will not be available and some...

Jeff,

thank's for your reply. I agree with you that it shouldn't be a big issue. What confuses me is the fact that BOL says that turning this option off is...

Anders,

first of all you should check the logfile to see what has been done and what hasn't. Second I know there was an issue with file cleanup in the RTM...

Rocker,

dbo is a database user, not a login. A login (sa) needs to be linked to this user.

sa on the otherhand is a SQL login and it cannot be deleted,...

Exec sp_changedbowner 'sa'

This will make the sa owner of the current database.

Markus

Where are two ways of doing this. One would be converting the status value from sysdatabases, the other is using the DATABASEPROPERTYEX function. Here's one example :

CREATE TABLE #SimpleDB...

I think I found the problem. On all databases there sp_helpdb reported an error, the database option 'default to local cursor' was set to ON. After changing this to OFF,...