Not sure what you are trying to see. Maybe one of these will be helpful. You can't read the transaction logs as you can an error log without...

Any chance your are trying to go from 7.0 Enterprise to 2000 Standard?

You may want to think about setting the xp_cmdshell proxy account to someone or somthing without any privileges.

Thanks for the input!!

Don't have AWE enabled on this server and I already have that SP in. This was a strange one and I had all kinds of...

I have a similar situation in my environment that I have not completely resolved yet. But thought I would share some of my findings.

I noticed that the login fails...

I have to agree that it seems to be taking longer than it should. Disabling the trigger sounded like a good idea. Investigating the index situation sounds...

What about selecting from a table using the alias name?

I forgot to add that I have had problems that were solved by increasing the number of threads I have to the file groups. Make sure you have...

We are using an EMC SAN for three instances on clustered servers, including SAP. Our performance is pretty good and have even migrated databases and servers to it,...

I created a function to do a recursive check, starting at the top node and going down to pull back all the children and parent. The function requires the...

I love the CONNECT BY clause 🙂 Hopefully SQL Server will implement something similar. I ran into the same problem some time ago. My solution was...

One more idea....

From what Iam reading, the Constraint maybe a BEFORE trigger.

Good luck w/ the research!!!!

I really wish SQL Server would implement BEFORE and AFTER triggers. Granted we have the ROLLBACK, but for design reasons the BEFORE trigger can...

Good luck w/ the research!!!!

I really wish SQL Server would implement BEFORE and AFTER triggers. Granted we have the ROLLBACK, but for design reasons the BEFORE trigger can...

If it doesn't have to fail, but just needs to exit the current Step then use a GOTO statement

-------------------------

IF <condition> GOTO goodbye

--else perform the other operations.

:goodbye

--------------------

If you absolutely need...