Opting for the left join, would mean a vertical split of the data into a number of tables.

As always ... it depends ... mainly on your performance goals, but as...

Keep in mind SQLAgent has settings (activated by default) for job history.

- Total number of rows

- Max number of rows per job

If you have many jobs, you may be hitting...

Never mind, I created a carthesian resultset because I didn't include all elements to be compared in the ON-clause of the join.

Now it's working a bit better, but still doesn't...

I got things working a little bit :crazy:

I have attached the sample data and the needed queries.

The problem is the comparison query never ends ....

This server has +/- 1400 shares...

You need to specify :

OR new file locations as proposed above.

OR use the 'replace' keyword to overwrite an existing database !

I advise to always specify the target file locations, so...

You may want to work with a delete loop of smaller chuncks of your data.

Keep in mind your logfile may grow during this operation.

I don't know where I got this...

For sqlserver I suggest you use the bigest allocation unit size your windows supports.

It will be the smallest unit of allocation for any file(extend) on that volume.

So the smaller it...

Thank you Jacob.

I'll give it a try.

Johan

Kaushalendra Singh (3/22/2009)

---

first we can change the password the then ran the jobs in sql server 2000.

folowing this staps

open the notepad

copy

then save the text file at changespassord.bat in c...

We don't hear that very often :w00t:

Thank you for the contribution and the urls.

keep in min to change the dblevel to 90 !!

Did you try to do it like this ?

Declare @ComputerNamePhysicalNetBIOS varchar(256)

Set @ComputerNamePhysicalNetBIOS = 'Server [' + @@servername + '] Running on - ' + Convert(varchar(128),SERVERPROPERTY('ComputerNamePhysicalNetBIOS') )

Declare @Subject varchar(256)

Select @Subject =...

It took me a lot of frustrations but I got it to work :w00t:

-- ...

If object_id('tempdb..#LocalGroupMembers') IS NULL

begin

Create table #LocalGroupMembers ( IdNr int identity(1,1) not null

, [ServerName] varchar(128)...

Advantages ?

Mainly you save drive letters

and you can use more than 26 logical drives for a single instance of sqlserver

BP say for performance you would need:

- tempdb on a...

Thanks again 🙂

It gets quit confusing (sheer volume) to find the right corner in the maze to get started. :hehe: