Something like this?

create table #x ( digit int not null )

insert #x

select 2234 union all

select 9100 union all

select 9023 union all

select 54101 union all

select 60001 union all

select 2034

go

Naming conventions is a subject there exists many thoughts on. I think the most true 'truth' about it, is that it's incredibly hard to come up with a 'good' naming...

Yes, that is correct.

In SQL Server, you can have either separate users/logins that is exclusive to SQL Server, or you can delegate that to Windows 'regular' accounts. This is two...

If you want to treat the two different tables as one, UNION (or UNION ALL) is one way to do it.

(borrowing Jeff's example)

declare @Table1 table (someval int, fname...

If you store your date as an int like 1060313, then what does 1060313 mean?

Is it seconds, minutes hours..? Starting from when?

/Kenneth

Is this the complex view or the slow report..?

Anyway, some thoughts.

The query example joins to other views. What do they look like?

The query returns * (all columns) - unnecessary many?

There...

If you give sp_helpfile the logical name of the log, it will report among other things, the physical filesize.

/Kenneth

I'm a little confused as to exactly what you want to do. Could you provide a small illustrating example, and also explain any rules regarding this sequence number?

/Kenneth

Charlotte, I just want to be totally clear - Noels soultion is not suitable for a trigger. If you put it in there, each and every transaction you're auditing will...

Though Noel's solution may work sometimes, I'd really not recommend to try that inside a trigger.

There's also some security considerations to take into...

Nice one Noel

Though the fact that it apparently works raises some questions about security..

The connection needs to be able to use xp_cmdshell. Haven't...

Was just thinking of the fact that in the end, these kind of 'name-splittings' never turn out to be as clean and simple as one first thinks. It's not the base format...

You could also try running

exec master..xp_cmdshell 'dir E:\WUTemp\NewProspectJoJo.fmt'

..and see what it says..

SQL Server rarely lies - but if it says something doesn't exist, it just means that it can't...

Not without some help. Your end, the server (SQL Server) needs to either:

1) Be told by the connection which IP it comes from

or...

2) Find some place where it can read...

Since the procedure lives on the server, the client must tell the server which IP it has when it connects.

SQL Server cannot 'reach out' and get the IP from the...