You're not alone Sloan. I was 100% absolutely positive that the comma was a syntax error.... until I did likewise - I got it wrong and then tried it...

You can use the sp_addserver stored procedure, with the 'LOCAL' option.

Look up sp_addserver in BOL.

Cheers,

- Mark

I agree with racosta.... profiler is sometimes (no, make that often) a necessity on a production server.

But, handing the profiling duty to the dev guys is something I...

A similar thng happened to me (on the indexed view question).

But, unlike you, I have no complaints.... for me, it said I'd gotten it right.

Cheers,

- Mark

Greg,

Sorry, I don't know why. (helpful aren't I )

However, after much grief over the years I've got in the habit of preceding most of my cmdexec steps...

Because the Copy SQL Server Object tasks appear to be hitting the same "work" files, maybe you can reduce MaxConcurrentSteps to 1 or include workflow to carry out the tasks...

Are there possibly any database names with invalid characters around them.... thus needing square brackets in the dynamic sql?

Not that I'm anti-cursor, but I do avoid them when I can,...

Ian,

You are right.

Linda

My mistake and apologies. In your trigger, are there any statements prior to your checking of @@rowcount? Most statements affect it.

Cheers,

- Mark

Another option:

 

declare @ss int 

set @ss = datediff(second, '1 Jan 2003', '31 dec 2003 23:23:59') -- for example

declare @ddhhmmss varchar(20)





set @ddhhmmss = 

 ...

You should use the NEWID() function.

Look up NEWID in BOL.

Cheers,

- Mark

sounds like you've got a good solution - it's straightforward, and it works.

Some other options:

a) Use model as the template (trouble is you may not want EVERY new database emulating...

I wouldn't expect upgrading to win 2003 to present different results - or there'd be people screaming at MS by now.

I may be in your full text queries. What...

No, the trigger will still fire if no rows are affected. Eg.

 

create table test1 (id int)

go





create trigger trtest1

on test1

for delete, insert, update 

as...

The @@rowcount will not have a value at that beginning stage of your trigger (ie. it IS set by statement that fired the trigger, but is not visible within the...

Use one of the many CONVERT formats. Eg:

select convert(varchar(10), orderdate, 120), count(*) from GeneralBooks group by convert(varchar(10), orderdate, 120) order by 1

Cheers,

- Mark