Viewing 15 posts - 11,656 through 11,670 (of 13,464 total)
SQL Server, or any relational database system for that matter, doesn't put data in any specific order unless you tell it to.
the primary key of a table is used...
February 4, 2009 at 10:45 pm
From BOL:
DDL triggers fire only after the DDL statements that trigger them are run. DDL triggers cannot be used as INSTEAD OF triggers.
So I think if you simply do CREATE...
February 4, 2009 at 10:37 pm
I took one of the examples I'd gotten here and modified it to get teh sp_helptext of the procedure being affected.
my audit trigger is called AFTER the CREATE/ALTER DROP event...so...
February 4, 2009 at 10:30 pm
triggers have their purpose...i think the bad rap triggers get come from people trying to do stuff that should never occur in side a trigger anyway.
I've seen requests on opening...
February 4, 2009 at 10:05 pm
the info is stored in the registry.
open regedit and search for one of the servers you know you want to eliminate. you can see which ones exist from there.
on my...
February 4, 2009 at 10:00 pm
first it's not too late. It is never too late to fix an issue and make something better.
it is very easy to fix, you just have to break out of...
February 4, 2009 at 9:29 pm
Excellent! glad we could help!
February 4, 2009 at 9:00 am
yeah, i don't know if it can be resolved...SP1 doesn't prevent a a bad execution from being built....SQL2005 still parameter sniffs, right?
February 4, 2009 at 8:53 am
yep same issue as the post here:http://www.sqlservercentral.com/Forums/Topic649831-8-1.aspx
i put a decent explanation and fixes there.
February 4, 2009 at 8:46 am
I think the issue you are hitting is called "parameter sniffing"; when the code is compiled into a procedure, the compiler makes a best guess on the parameters when it...
February 4, 2009 at 8:41 am
I didn't want to be obvious and choose Darth Maul or something; obscurity is good sometimes.
how about we go with Bill and Teds Excellent Adventures? I could dig an avatar...
February 4, 2009 at 7:26 am
the best way is to update from a list of known last names...you cannot assume that every last name that starts with mac... gets it's 4th letter capitalized...
macaroni, machiavelli are...
February 3, 2009 at 12:22 pm
i think your HOUSE_EVENT table is going to have just certain statuses that are relevent to the current status of a property...many can be ignored i assume?
correct me if i'm...
February 3, 2009 at 12:17 pm
lol...you know the answer....you'll have to add a primary key to the table
...even if nothing uses it business wise, you can add an idnetity() column, make it the primary key,a...
February 3, 2009 at 7:20 am
when you install, you have the choice on installing a default instance or a named instance
if you chose default instance, the SQL server is the name of the machine....
sqlcmd -U...
February 3, 2009 at 6:47 am
Viewing 15 posts - 11,656 through 11,670 (of 13,464 total)