here's a situation where I've expected a trigger to rollback because I raised an error.

http://www.sqlservercentral.com/Forums/Topic622424-338-1.aspx

I've also seen triggers still commit even though a Level 14 error was raised by...

you'll need to explain exactly what you want.

how can you have data BASED on a count if you don't USE a count?

give us the REAL table with sample data, and...

you need to select from the master table, and include the group as a sub select there somewhere, ie

SELECT *

FROM SOMETABLE

INNER...

Here's a detailed explanation i saved from an MS blog a while back:

quote:

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

The reason for the performance difference stems from a feature called

"parameter sniffing". Consider a stored proc defined...

makjain (2/7/2009)

---

Then too i have 1 question if THEY provide me username and password for sql database then how my web page will work as they have windows authentication.

Will i...

If it's not your own server, for example if it is going to be hosted at GoDaddy or some other host, THEY will give you the user name and password...

you don't need a trigger for this...you could handle it automatically by making status a calculated field instead of a bit you have to update:

[font="Courier New"]CREATE TABLE TEST(

    SID INT IDENTITY...

i've got a stored proc i made that i named sp_getDDL, which trolls thru the table definition and it's columns and builds the script for the table; it's probably...

just change to a temp table, no problem:

CREATE TABLE #LinkedServers (

...

my new avatar makes me feel more intellegent...err...inteligent...err..intelligent!

yep you can fix this:

Tools>>Options>Text Editor>>File Extension

type PRC, choose Query Editor and hit Add; next time you load that file extension, it will use the syntax highlighting engine:

if you need to fix the LineItem table prior to archiving it, you might want to do something like

UPDATE LineItem SET LineItemID = LineItemID + 240000000

that, by...

this is just a prototype for a single database, but it's easily adaptable i think.

I'm assuming that the current server has all the linked servers....so I thought why not search...

specific procedure is slow...but runs fast if you run the statement in SSMS?

sounds like parameter sniffing to me.

when the code is compiled into a procedure, the compiler makes a best...

fragmented MDF files happen in situations where the file gets shrunk, or needs to autogrows to hold more data.

ideally, you pick an initial size of a database so that the...