you could do several things here

1st - disallow recursive triggers using

sp_configure 'nested triggers',0

but this might break other DB functionality

possibly i might suggest performing a check on the columns...

ok - let me be clear

the original post indicated that i wanted an Efficient method of getting the max value from Rown_number()

but the query inside the CTE/subquery may have...

lynn thanks - i will review this

but to note - changeing my original requirements??:-P LOL -

i think you'll find the original post said

"In this instance and send that back...

that's not really do-able for me

as i said, this might be a huge query with maybe 15 tables

so your example of

with PagedData as (

select

row_number() over...

ok - slight modification to my post

i can't supply it as an extra row in the result set - sorry

one additional thing that might make it easy (on top of the last post)

create a schema for your procs

set the schema as the new users default schema and grant permissions...

Karsten (7/7/2009)

---

I am a user for SQL Server with Wonderware InTouch. InTouch is a process visualization tool. InTouch is using the SQL Server for the Alarmdatabases and recipe handling.

I...

hold on - if they're linked servers then go to your target server, create a new login and then change the linked server login to use the new username and...

you can't script the login to the linked server - microsoft put a lovely feature in that strips out the password and replaces it with '########'

there are a few brute...

I've done loads of this and it could be any number of issues

when you're dealing with backups etc in 2008 (not sure about 2005) you'll need to make a credential...

you'll need to post your query and table structure for us to help you more.

i suspect your null values are being removed by aggregation, or if you have no entries...

What kind of infrastructure exists between the user and the server?

I suspect if they are on different networks then you are going to have to use VPN or FTP to...

they all have pros and con's -

idera sql diagnostic manager tends to be a little flaky and actually consumes a fair amount of CPU from the sql box with the...

can you post what you are attempting to do. add a subscription? add an article?

if you have renamed your server then you also need to let sql server know

if...

seems to me you might be better creating a view on your sql server and then let your application read from the view

that way you get some decent sql that...