Bilal Khawaja

  • Interests: Programming

SQLServerCentral Article

Dynamic Connection Strings in Reporting Services 2005

Reporting Services is one of the most popular features of SQL Server 2005 and there have been a tremendous number of enhancements to this subsystem. New author Bilal Khawaja brings us a look at dynamic connection strings and how you can have one report pulling data from different servers.

(19)

You rated this post out of 5. Change rating

2008-04-03 (first published: )

20,866 reads

Blogs

Post-quantum key exchange – Insurance policy for your packets

By

AWS recently added support for Post-Quantum Key Exchange for TLS in Application Load Balancer...

Plan your 2026

By

If you don't have a plan, you'll accomplish it. That's not a good thing.

Another Change

By

Today Redgate announced that we are partnering with Bregal Sagemount, a growth-focused private equity...

Read the latest Blogs

Forums

Fantasy Football 2026

By Steve Jones - SSC Editor

The thread for the league in 2026. Players from last year have priority.

Certificates expired - Can't restore after creating new certificate

By WebTechie

The previous DBA created a certificate which expired 12/31/2025. I came in hoping to...

advice on diving into devops for managing BI projects

By stan

hi , i know this is a sql server forum but i think my...

Visit the forum

Question of the Day

Which Table I

I have this code in SQL Server 2022:

CREATE SCHEMA etl;
GO
CREATE TABLE etl.product
(
    ProductID INT,
    ProductName VARCHAR(100)
);
GO
INSERT etl.product
VALUES
(2, 'Bee AI Wearable');
GO
CREATE TABLE dbo.product
(
    ProductID INT,
    ProductName VARCHAR(100)
);
GO
INSERT dbo.product
VALUES
(1, 'Spiral College-ruled Notebook');
GO
CREATE OR ALTER PROCEDURE etl.GettheProduct
AS
BEGIN
    SELECT  ProductName
    FROM product;
END;
GO
When I execute this code as a user whose default schema is dbo and has rights to the tables and proc, what is returned?

See possible answers