you must have physical control of the server to regain control;

basically you end up starting the server in single user mode; in that mode, any local administrator gets promoted to...

question makes sense sure;

i think the question is all about css layout;

so if you added a default to theTD class, it might do what you are asking, and is...

can you try this and tell me if it outputs what you were expecting?

DECLARE @tableHeader varchar(max)

DECLARE @tableTail varchar(max)

DECLARE @tableHTML NVARCHAR(MAX) ;

SET @tableHeader =

N'<H2>DBA Jira open Calls</H2>' +

N'<table border="1">' +

N'<tr>'...

simon, I'm not sure; i didn't see anything explicitly saying FOR XML in what you pasted; i always construct my html in three peices; header/body/tail;

because the FOR XML needs...

a very basic example of including extra tags:

DECLARE @HTMLBody varchar(max)

Select @HTMLBody = (Select Row_Number() Over(Order By is_linked, name) % 2 As [TRRow],

...

it depends;

you can use css to define the size fo the td cells(width: 210px;min-width: 100px;), or set them to not allow wrapping at all, depending on your needs (white-space:nowrap;), and...

I learned something here too; I didn't think impersonation was allowed,...

dwilliscp (8/22/2012)

---

I have two servers that should be linked.. and we want to use a domain user ID to link then. But when I put in <Doman Name>\<user ID> and...

CELKO (8/22/2012)

---

Re-write the proc to use a table valued parameter and lock yourself into proprietary MS. Or you can Google us a set of two articles I did on long...

well a restore in SQL server is all or nothing. the backup is an exact copy of the commited transaction data.

if the backup file is corrupted, the backup simply fails,...

ahh i missed that somehow;

i think Adding Dereks idea, just a couple of nested REPLACE functions to change (nnn) to (n) and (nn) to (n) would be the easiest.

personally I use a purchased copy of CoreFTP Pro($40 bucks) , which supports SFTP and other secure FTP protocols;

I can call it from a command line, where i pass it...

you can do it with nested STUFF statements.

play with this till you understand it:

with MYCTE(val)

AS

(

SELECT 'A(1).BC(10).DEF(100)' UNION ALL

SELECT 'A(4).BC(34).DEF(754)' UNION ALL

SELECT 'A(9).BC(78).DEF(957)' UNION ALL

SELECT 'A(9) AND OTHER STUFF HERE...

also, my test as it sits assumes both Premium and Quantity can never be passed NULL; if it's possible, you might want to change the comparison to ISNULL(inserted.Premium,0) <> ISNULL(etc...

the first part of your trigger is not a valid test; it's grabbing an aribtrary values, instead of testing ifpremium or quantity changed;

so on a multi row update, the test...