Group in New page

i am new to reporting services. I am trying to create a report group by salesperson . I was able to…

Problem with DTS packages in 2000 while migrating on sql erver2005.

I have migrated My sql server2000 database to the sql server 2005, The database migration is succe…

windows to sqlserver authentication mode

🙂 Hi Dears Hope Everyone are Doing Fine? I have a Prob with installation.. please resovle it. I hav…

SQL Agent not able to execute package

Im sure this is a common proble. When I run the SSIS package manually it works finr, when I import …

Wiring Package.Variable to package Variable and EXPRESSION for sa PASSWORD

My SSIS package uses EXPRESSIONS which reference Package.Variables in my dtsConfig file. Using Pack…

I don't want to export my header

I've created a report in SSRS. When viewing on-screen, we want people to see the Page header. How…

SQL Services will not start... (SQL Server 2000 SP4)

I have a SQL 2000 with RAID 1, last day an error happened with the second mirror, after restart it,…

Need to know last date\time a table was updated

I need to know when a table (actually several tables) last had data INSERTed, DELETEd, or Modified.…

I have a SQL 2000 with RAID 1, last day an error happened with the second mirror, after restart it,…

Printing Report by clicking an ASP.NET button.

Hi, Is it possible to print a report that is deplyed in server by clicking an asp.net button. I kno…

what is read ahead read/

hi forum what is read ahead read, where and when the sql server recognises these reads and how ? Ma…

xml data about query plan and profiler

I played a bit with the profiler and tried to see if I can find a good use to the events "showplan …

Duplicate GUID column values in two tables...

Hi, I have a question regarding the GUID columns. I do not know much about this GUID data type and …

Color compatibility between Excel and SSRS

Hi, I have SSRS Reports created and rendering in Excel format. I used a custom color(mentioned in e…

Database Mirroring and SQL Server 2008 Native Client (ODBC)

Hi, We are intending to set up Synchronous database mirroring in SQL Server 2008 (Enterprise Editio…