Hi ,

On a default installation of SQL Server all of your drives are on "PRIMARY" filegroup. eg. (a: d: e  This error means that...

Hi,

SQL Server gets its time zone from the operating system. On the server go to control panel and choose Date and Time settings. There is a tab called Time Zone....

I used function's to do something similar. However I also made shure that the table was properly indexed and also made shure that in the select statement I never put a...

If you use Enterprise Manager, on the machine that OLAP (AS) is installed, you will see a DTS task called Analysis Services Processing Task. You can do what you want to do...

Thanks for the article. I found it informative as I am not used to Hurricane's in South Africa. We don't have Hurricanes's, Tornado's and earthquakes!

It looks very much like VB and I will have to "get over it" But one thing I miss is the Query builder. Where you get a graphical display of...

I have had a similar experiance where the JOB is successfull and it did not complete some steps. Use your DTS package logs to see what steps took 0 ms...

If your username is not a Data Base Owner you will have to specify the dbo.table. (Unless you fiddle around with allias's)

However you do not have to specify the Database,...

Hi

Have you tried BULK INSERTS? If certain criteria is met the transaction will not be logged.

Hi,

I cant see what the problem is from the error log. Have you set the DTS package properties to create a log file. The package log file will give you a...

Try SP_HELP_JOB @job_name = 'JOBNAME'. This will give you some of the info that you wan't but as to who modified the job I dont think that you can get...