I believe this error occurs when one or more databases are owned by server's login which doesn't exist anymore. Try to run this query:

SELECT dbid, SUSER_SNAME(sid) FROM sysdatabases

and see if...

Each node will have its own "virtual" name.

Let's say nodeA and nodeB are your physical machine names. clustnode is your cluster name. You'll then have sqlA and sqlB - network...

Mark,

AFAIK you should login to a node which currently owns the instance you're going to upgrade. I'm not sure if it really has to be an node where the virtual...

If I understand it correctly you want to build dynamically a pivot table.

I don't think it can be done with a single SELECT statement.

There is an article in SQL Server...

try:

select distinct A.rowid, A.value as charge, B.value as lname from

test A inner join test B on A.rowid=B.rowid

and A.caption='charge' and B.caption='lname'

Try two quotes instead of one:

Select * from openquery(DB24,

'select t_cprj, t_seak from BAAN5TAM.ttppdm600577 where t_psts LIKE ''2''')

elvistheprince,

I also saw that for some reason SQL became extremely slow when given the large number of values in the IN clause.

I'd try some workarounds for that:

1. If the list...

Open the job "Properties" dialog. Go to "Steps" and open "Edit" dialog for step one. Go to "Advanced" tab. Specify "output file" and check "Append output" checkbox. Save the changes...

It's just the way how ADO queries SQL Server. To find more about sp_cursor sp look at "System Stored Procedures" in Books-On-Line. There is a section on sp_cursor... Sps at...

Include "SET NOCOUNT ON" in your SQL batch

Look at "Security Account Delegation" in the BOL. There are also knowledgebase articles on MSDN.

No, backup and restore won't help.

If you really don't want to drop and re-create the table you can try to create a clustered index if you don't have one already....

From running Profiler you can see that when you check "Move pages" checkbox EM executes:

DBCC shrinkdatabase('yourdb', 10).

When you leave this box unchecked the command executed is:

DBCC shrinkdatabase('yourdb', 10, TRUNCATEONLY...

Two things:

1. You can't have P as part of the string. It must be from A to F or a digit.

2. The first part should be 8 chars long. You...

Check this article from Microsoft:

http://support.microsoft.com/default.aspx?scid=kb;en-us;324432

Also, run DBCC SHOWCONTIG to see what's fragmented in your database.