Viewing 15 topics - 278,956 through 278,970 (of 283,917 total)
Topics
Started by
Posts
Last post
I noticed that the error I raised in my trigger does not have any effect on the sproc that triggers…
2 replies
Hi, We have a package that runs every day - 99% of the time it runs with no error - then out of the…
5 replies
What is a quick way to grant ALL DATABASE objects (SELECT, etc) to a user or role via a script or u…
2 replies
Hi all, I looking for a script that moves indexes from one physical location to another...basically…
1 replies
We have 2 SQL servers which we are trying to make identical. Problem is that one server is setup to…
5 replies
When I execute The Stored Procedure SP_Databases in ADO, I get the following error if the user does…
4 replies
I am a relative beginner to the sql/xml relationship, but i am begging to see the power. Does anyo…
3 replies
This is what I am doing: * Create a temp table. * Insert records into temp table From T1. * Get rec…
7 replies
In the following statement it returns Null if it can't find just one of the rows in the Stats table…
1 replies
Greetings all Experts out there, I have a typical problem on My Databse server (Win2k-all patched…
6 replies
I have a database MyDB. It has roles Administrators and Employees with members Admins and Emps resp…
10 replies
Does anyone know of a script that would loop through the resultset of the sp_change_users_login 'Re…
2 replies
Over time some of my triggers have gotten lenghthy as value is added to the procedures. Some functi…
5 replies
Does anyone know where I can learn why Constraints are better than triggers. BOL explains that the…
7 replies
I've got over 1100 SPIDS that a I know were caused by bad ConnClose() asp fn. Is there a way to cle…
3 replies
Viewing 15 topics - 278,956 through 278,970 (of 283,917 total)