Try to use osql instead of EM.

Do disable the SQL Agent (it also can take the connection away)

If this fails, make sure that the Cluster Administrator does not take...

You would need to build up the pivot statement and then execute this. An example is on:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=338&messageid=367396#bm367610

Regards,

Andras

In SQL Server 2005 you can use OPENROWSET(Bulk as:

INSERT INTO mytable
        ( somecolumn1
        , imagefromfile
 ...

Wim,

During a server restart SQL Server will still ensure that the new timestamps will be greater than the previous ones. SQL Server persists the timestamp value in its databases' boot...

You can find this out for individual users wit the help of the has_perms_by_name function.

For example to see if the current user has perimission to sys.syslogins:

SELECT has_perms_by_name('sys.syslogins', 'OBJECT', 'SELECT')

To see...

Are you using any user defined types, xml or CLR types in the temp tables you are creating? SQL Server SP1 has introduced something what I call self-deadlocking transactions, but...

The user defined function in the first post on http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=338&messageid=391111

can do it on 2000.

Andras

If you go for the CLR aggregate, the CLR aggregate may get its input in any order depending on how the query optimizer decides. Concatenation is not commutative

Hi Don,

There are some excellent new features in SQL Server 2005, like support for CLR, the Service Broker, and support for XML. But at the same time there are many...

I wish there was a book like this, it would have saved me a lot of time with SQL Compare. Unfortunately, I have not seen any, although this is an...

Have a look at http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=338&messageid=391111

Peter posts there a very nice and fast solution that uses XML PATH.

Regards,

Andras

Hi Robin,

it is probably worth posting this question to the SQL Server 2000 forums (http://www.sqlservercentral.com/forums/messages.aspx?forumid=9)

This one is for SQL Server 2008 (Katmai). Also, since I assume that eventually your 2000...

If you try to read the message in sections (by specifying length_in_bytes and length_in_bytes) can you read the full message?

Andras

The system tables between 2000 and 2005 have changed quite a lot. The transaction log very much relies on these tables, so this difference prevents log shipping between 2000 and...

Encapsulating the above into a select with part of the same group by statement, and adding a MAX(RE), MAX(CE), MAX(MC) .. columns (assuming their values are not negative) could work.

Something...