Hi Henrico,

this is how i setup.

new server name/instance: newservername (Default).

old server name/instance: oldservername\instancename.

so, because I'll decomission the old server. i will user the oldservername\instancename as the alias...

oops I thought ssscommitted is your alias. tx Henrico.

Hi SSCommitted. thanks for the reply.

I've tested the alias. it'll only work if I setup the alias on server, it doesn't work. only when

i set the alias on the client...

the question should include SQL versions. the following does not work prior to 2008.

INSERT INTO @student

VALUES( 'Hardy', 100), ('Rocky', 98), ('Panky', 99)

tx GilaMonster.

btw, it can be fixed by adding another index or using a hint. but i just wanted to know what is going on. cheers.

Hi Thomas,

isn't just opening 'design table' from SQL management and edit the column to have identity or not, works as well?

or it might be just me missing the point.

Cheers,

DK

i've tried to use the profiler. but i think the command that runs the actual report is not a sql command (though you can see it trying to get the...

well, the idea was to create a scheduled job to create and send the report as a file.

to get just the information, off course i can just send a...

Thanks Paul. 🙂

I can't see the script. is this only me?