DB MAINTENANCE PLAN ERROR

The Gurus, A very good day to you. I have got an error which I have no idea why i'm getting it. I h…

Multiple indexes on the same column

Guys, Is there anyway from system objects I can find all the columns which have more than one index…

values in table header not same as db fieldname

I am modifying an existing report that was created by someone else. The report is pulling from a s…

Issues Attaching MdxStepByStep.mdf

exec master..sp_attach_db 'MdxStepByStep', 'C:\Microsoft Press\MDX SBS\Setup\SQL Server\MdxStepBySt…

populate Volume_YTD and Volume_LYTD columns

I have a very un-normalized table and have been asked to add two columns, Trx_Volume_YTD and Trx_Vo…

Perfmon Counter Thresolds

SQL Server 2005 Reporting Services Failed to restart

Good Day, We deployed the latest Windows uodates to our Reporting Services Server. However when we …

Hacking attempts

What's going on with these posts: Informatica DS sa Hacking or spam, but I'm not opening those atta…

Field should read vertically instead of horizontal.

I am trying to create folder labels for our Business Intake department. They currently use Busines…

Creating Employee Dimension and Importing data

I have the following table in another SQL DB. I am working on a plan for a new SSAS cube and think …

query needed in mssql 2000

i need the following query in 2000.please look into this. Select * from ( SELECT MED_NAME AS MEDICA…

Creating a job using a package?

Hi all, I am new to SSIS environment.I want to transfer data from excel to sql server for every 5mi…

problem with ssrs 2008

Hi I am generating the reports using the cube as a source. when i summerize the data in cube browse…

Scheduling 2008 Packages with SQL Agent 2005

Hi all, Having somewhat a debate with some DBAs. I designed an SSIS 2008 package. While I know th…

finding out how a user gets access to my databases

All users have access to my database via a security group maintained in active directory. One user …