So, add all records (without distinct) and then remove duplicates. There is something not right with the database logic, when it depends on physical order of data.

My understanding is, sorting is the most effective way of removing duplicates, as it eliminates need of costly lookups. Could you tell us what is the scenario and goal you...

you can look how the database was configured before it was backed up using restore filelistonly command, like here:

restore filelistonly from disk='E:\sqlbackup\mydatabase20071121.bak'

Hi,

You can create your procs and view with WITH ENCRYPTION option, this will prevent others from viewing their code. Be sure though that you have these objects scripted.

HTH,

P.

Well, does database 'Automation' exist?

you have to enable ability to execute xp_cmdshell, which by default is disabled in SQL 2k5

there's an example in BOL, how to set this value.

-- To allow advanced options to...

Thanks Andras, that was excellent.

sure, you have to set up a SQL Agent job.

maybe this is what you are looking for:

select user_name() as , suser_name() as [login name]

hth

Piotr

what's the remote server? sql? so if you create a linked server, look for sql agent and how to create a job. then in a job step you can call...

did you consider using simplest - linked server? you could set up a job that would copy data from that server over to your database at required pace.

Hi Christian,

CTEs are 'physical' rather than 'logical' construct, as they produce data for use in subsequent query, right? So you can write a CTE query that performs heavy sorting or...

it's like with select: avoid implicit column references. if order of columns in your table changes, inserts may fail and it can be hard to track.

this query works and it...

how do you make this excel query? are you sure that the excel process is closed after being used?

Higher versions do not support User Instance Mode. So, if you rely on it, you may get burned. You cannot connect to user instance using tcp/ip, only named pipes. Connection...