Dorian Gray (6/15/2009)

---

I am at my wits end - any help will be appreciated. I have a tester connecting to a SQL2K5 db installed on my pc at work...

oops double post sorry folks...continue below

if your developers are on the same network, then I don't believe it can be done.

each instance of SQL server listens to one port...no problem.

a router can take traffic from...

alias? I'm not clear on your question. which alias are you referring to?

You might use port forwarding because you have 10...

port forwarding is not handled by SQL Server, it is typically handled by a router that establishes the firewall between your internal network and the internet.

here's a screen shot of...

An Identity column will not meet your requirement, since you need it to reset back to 1 with each claim number.

as you've probably already found, there's no inbuilt way...

Object:Deleted would be the dropping of a table, foe example. the default trace only tracks object level events: CREATE/ALTER/DROP of database objects (DDL)

you would need a DML trace(Data Manipulation)

I'm adding...

do you mean using the WITH clause with a Common Table expression, or do you mean where you use the WITH clause to use a hint, like WITH(TABLOCKX)?

a CTE would...

I think you have two choices; raise an error like you were planning, but you could also use an INSTEAD OF trigger, and ignore any changes to the ID column,...

you'd be looking for a DELETE or TRUNCATE command; there's nothing in place to look at where it happened.

the default trace would have information if the table was dropped, but...

here's what i do:

i create a view for any trace i create, so I can easily access it.

here's a code example:

--review all my traces

select * from sys.traces

--find the path to...

excellent. with the table definitions it is REALLY easy for us to help. good job providing us with that.

here's a basic example that works; note the key is to use...

this is known as a "running totals" problem. running totals require a defined ORDER BY...wkether it is a PK, or alphabetically, or whatever...your example so far does not meet the...

here's the first way i thought of: compare the value to the convert(,int) of itself.

declare @number decimal(18,4)

Set @number = 10.0

--here's one way, compare the value to the integer conversion of...

the CONVERT function has a third parameter which has some built in formats for converting datetime to varchar:

char to datetime:

select convert(datetime,'090611',12)

--results:

2009-06-11 00:00:00.000

and going the other way, datetime to char

select convert(varchar,getdate(),12)

--results:

090611

using...