Wow here I thought 2008 was only BI stuff .....we have a few 2005 clusters ect but the rest of the enviroment is 2000 - all our consolidation servers ect...

Howzit .

SQL doesn't keep these changes in a log as such . You have to design a strategy that will keep the changes for you and when it occurs...

...not to worry anymore ...under th reportmanager forlder  my web.config file was missing , this file have code that points to all the...

Thanks , but not every database get's created as per the model database .....if you find anything else please let me know ...

The way I see it is when you...

Italian for goodbye....I think

Cool , no problems ....CIOW

if you took that as an insult that is your problem......then ask the forum administrator to give you a different nickname .....

Just a quick one use the Db2 driver that comes with Microsoft host integration server , there are no limitations for instance the driver that comes with IBM or DB2...

Remember that when you drop a Publication or a subscription SQL have to do alot of work in the background ..one is to I call it "unflag" all that tables...

Hi .

What we have found was that when you users are from different domains and you have NT 4.0 domain controllers and windows 2000 Dc's, you cannot do 2 authentication...

Thanks , I know how to use the options given , just thought there was a way to view deadlocks I didn't catch , because some nana killed the process...

If you query the table only using the 3 columns why would sql query all columns ?? doesn't make any sence what you are saying ..the query should perform fine...

Thanks for all the feedback guys ....

There is one thing though I will not reindex the indexes ..I am going to drop and recreate them ..start off fresh ..I do...

Hi there

Seems that there is a problem with your distribution agent . Have you looked at your agent history to see if there is any problems ? ...maybe create...

Howzit ..

Make sure that the sql service account has full control permission on the drive or folder where the datafile resides .If you use the local system account make sure...