lazy writer (12/14/2010)

---

Hi

I have created snapshot replication while creating this I have chosen options like generate snapshot immediately not on demand or schedule.

Here my doubt is for the snapshot...

Please keep in mind that the "fix" you used will only work if the database is set to Compatibility 80.

This means:

a) You won't be able to use the new 2005...

Restarting the SQL service, whether from just restarting the service or from rebooting the server/VM, dumps all traces except the default trace (usually trace ID 1).

I'd take a look in...

For that, you'd use a cursor. But there's no reason to. You can use Output Into to insert all the rows at once, then get all the IDs...

CirquedeSQLeil (12/14/2010)

---

GSquared (12/14/2010)

---

Alvin Ramard (12/14/2010)

---

GSquared (12/14/2010)

---

How about a horse stepping on an iMat?

...

iMat? You'll need DBCC...

Any complex conditional formatting or nesting in the report?

Mark-101232 (12/14/2010)

---

Is the XQuery ceiling function allowed?

WITH TESTDATA(Number) AS (

SELECT 12307.96 UNION ALL

SELECT 2207.96

),

XMLData(data) AS (

SELECT Number AS "@Val"

FROM TESTDATA

FOR XML PATH('X'),ROOT('R'),TYPE

)

SELECT r.value('@Val','float') AS...

That won't "round" correctly if the...

Did you remember to turn the trace on? sp_trace_setstatus needs to be run to turn it on. Till you do that, it won't create any files.

Use XQuery to shred the XML, and use an OUTPUT clause to get the IDs from the insert.

You'll start with this:

DECLARE @XML XML;

SELECT @XML = '<Individual InternalID="154805" Action="Update">

<InsertUserID>ASDZXCCFG</InsertUserID>

<InsertDateTime>08-29-2008 17:13:57</InsertDateTime>

<UpdateUserID>SYSTEM_USER</UpdateUserID>

<UpdateDateTime>13-05-2010...

Alvin Ramard (12/14/2010)

---

GSquared (12/14/2010)

---

How about a horse stepping on an iMat?

...

iMat? You'll need DBCC TimeWarp for...

How about a horse stepping on an iMat?

Stefan Krzywicki (12/14/2010)

---

GilaMonster (12/14/2010)

---

Thunderstorms here, but no snow storms. (I'd worry if there were)

Want some entertainment? I give you Gus's reply here http://www.sqlservercentral.com/Forums/FindPost1034345.aspx, nominated for comment on the week.

It almost...

GilaMonster (12/14/2010)

---

Thunderstorms here, but no snow storms. (I'd worry if there were)

Want some entertainment? I give you Gus's reply here http://www.sqlservercentral.com/Forums/FindPost1034345.aspx, nominated for comment on the week.

It almost resulted in...

Caruncles (12/14/2010)

---

Yes, my first attempt was on a temp table of sequential numbers comparing to the live table.

The only reason it matters is because I'm trying find out if...