this is my stab at nested set. i generate on every set of the table.

i am looking to refactor and trim it down at some point.

if this is any help...

Cheers for that answer is helpful. I have used SQLBulkCopy to load from an MSMQ and the performance was really good.

Thanks for the advise.

I am going to stick with the cmdshell.

I apprecieate the whole anti-pattern situation but unfortunately if i am going to use SSIS i will be writing outside...

Hi There

Not very helpful as SSIS still asks for a file as the format file.

So you still have the format file on the drive.

Also SSIS packages are outside of the...

Hi Thanks for your reply.

Not sure what happened but we downloaded some new media from the volume licensing site and it worked fine.

Thanks for your advice and that would have...

I thought that might happen Maddy fiddling with the code can be really good but you usually fall flat on you a**e regularly.

Another option would be to combine the two...

Hi Yes

I have tried all of these (daemon magic and virtual drive) and on my pc i have tried using the actual disc.

The problem only occurs on the servers and...

You could put an Expression around the possible values.

And use the value of the other parameter to define the possible values.

And then do not present any options.

Potentially you could write...

I have also made sure that the agent and server accounts both have visibility of the cert by logging onto the box and checking mmc to see if the certs...

Have you looked in your maintenace plan for a notify operator task.

Delete this and you shouldn't get any more emails.

Hi there

I tried to change a collation of a sql a while ago.

I didn't have any luck doing it.

Eventually i just got my mdf ldf files and migrated them to...

I would only imagine you would want to do this if you could quantify your seperate cross references against each other.

e.g. if a document had a monetery value and so...

When is that error thrown?

What was the aim of your rebuild?

Where you trying to change collation?

Sorry for the questions

Hi

I am also finidng it hard to see what you are trying to achieve.

You can add totals to you selects using "with rollup" or "with cube"

hope this helps.

How many distinct values do you have for the following fields ?

[Activity] [varchar](512) NULL,

[Username] [varchar](50) NOT NULL,

[GroupName] [varchar](50) NULL,

[CallerID] [varchar](50) NULL,

[EventMsg] [varchar](50) NULL,

[NASIPAddress] [varchar](50) NULL,

[AccessDevice] [varchar](50) NULL,

[NetworkDeviceGroup] [varchar](50) NULL,

[ActivityID] [varchar](50)...