ahh that's just syntax; the SET switch is for IDENTITY_INSERT, all one word with an underscore,no brackets around identity; i fat fingered my example and forgot the underscore.

--you had SET...

he had a similar thread on this;

i think the original poster is trying to get a formula like (#records matching my WHERE clause) / Total Records, but he thinks it...

Seriously? you need to ask? just by the question itself, you can tell it involved moving something(migration)

from one server to another vs upgrading an existing server?

you are posting...

i just saw something with that same question here that woudl probably answer the question more completely.

another thing I've done is use a Tally table to split the company name into single words....then try to match the single word against another copy of the table;

that way,...

apache i don't know SSIS, but i know .NET;

I've already written some code that i use in .NET all the time that takes any dataset and returns the data as...

Hi Neel;

I'd expect anything called 10K times to be in the realm of a max of 400 items per second; so for 10K calls, i'd expect that to take 25...

dynamic sql....

declare...

why can't you script the table out? and change dbo to the new schema name?

explain a bit more why you need to clone the table(and the data?) more than one...

what language are you using on your web page? what have you tried so far?

you gave us little information, and the question seems more oriented to the program you are...

with a non-express version of SQL, the SQLAgent is used to perform jobs on a schedule, like backups and other maintenance tasks.

since Express doesn't include the SQL Agent, you'll need...

edward are you familiar with the SqlCommand.ExecuteNonQuery Method, that is part of the (System.Data.SqlClient) class?

that is how you'd call a command that has...

the best way is to script the table out;

you can use the INTO [newtable] with a SELECT, like the script below for something fast and easy, but you'll...

better way? no...different ways , yes.

you are going to use the tools you know, and get the job done. I don't see a problem with that at all.

my background is...

billa i could not find the way to get more than 1000 records via linked server;

looks like it is much easier with powershell; by assigning it a page size, you...