Viewing 15 posts - 181 through 195 (of 224 total)
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...
March 5, 2003 at 2:40 pm
Any chance your are trying to go from 7.0 Enterprise to 2000 Standard?
March 4, 2003 at 10:22 am
You may want to think about setting the xp_cmdshell proxy account to someone or somthing without any privileges.
February 27, 2003 at 2:06 pm
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...
February 3, 2003 at 3:40 pm
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...
February 3, 2003 at 12:17 pm
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...
January 6, 2003 at 3:50 pm
What about selecting from a table using the alias name?
December 4, 2002 at 12:06 pm
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...
November 22, 2002 at 1:06 pm
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,...
November 22, 2002 at 1:04 pm
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...
November 12, 2002 at 10:19 am
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...
November 12, 2002 at 10:14 am
One more idea....
From what Iam reading, the Constraint maybe a BEFORE trigger.
October 4, 2002 at 6:37 pm
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...
October 4, 2002 at 6:34 pm
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...
October 4, 2002 at 6:34 pm
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...
October 3, 2002 at 1:28 pm
Viewing 15 posts - 181 through 195 (of 224 total)