Steve:

Thank you for your reply.

Nice reminder that if a person takes on a new position one of the first things to do is

1) identify which databases are protected by...

From all the discussion it still seems like aside from having the backup of the certificate file that was saved with the private key by password "abc123"

that when the...

Just wanted to add the comment for a user that might not know ... if instead of using truncate to clear the table the statement was to "delete" , then...

It was MS Dynamics GP direct connection and the connection through Scribe GP adapter.

Thank you all for the replies.

The applications do connect using a SQL login [integrated Windows login is not supported by the application]

It is good to know that others have experienced...

Gail:

Thank you, that makes the status returned by "Verify" make sense.

The first part of the backup is valid ... so I will trust that it is a true failure and...

With this one I have not yet tried using it in a restore. The full backup is quite large and the test environment is not ready for a change...

Thank you for the answer. I knew the standard extent size is 64kb but was thinking that maybe there was a mechanism for escalating the size [similar to what...

I guess this upgrade is using the "online" option . It doesn't give me a chance to tell it how to do the index build.

I am running an upgrade that modifies a couple of very large tables that have multiple indexes. I do not need versioning for this and it is forcing the...

This seems a good discussion to clear up my understanding of using "select top xxxx ..."

I've always read the description to be that when an "order by" is not used...

What is the lowest level of permissions that a user has to have to use the script wizard?

Have not been able to find that. I thought if the user...

Thank you both. There was an article somewhere referring to the limitations for identity column values with respect to replication. That is what sent me looking.

The chart answers...

Is there a chart somewhere that shows the maximum number of identity values for the data type used when creating an identity field in a table?

I've searched for this in...

I agree that the 2008 Activity Monitor is a downgrade. The look and usability is far inferior to the 2005 version [which was a nice improvement over the 2000...