SQL SERVER : How to List All Email Subscription configured in SSRS ?
Often I used to get request from my business managers to get a list of all subscriptions configured in SSRS...
2012-09-27
14,826 reads
Often I used to get request from my business managers to get a list of all subscriptions configured in SSRS...
2012-09-27
14,826 reads
In Master Data Services (MDS), I received a strange error when I was calling a stored procedure (stg.upd_name_Leaf) to batch...
2012-09-27
2,377 reads
“New York City…center of the universe..” – Rent
I’m off to New York this morning for the start of the 2012 SQL...
2012-09-27
1,704 reads
I”m working with a client in Orlando that needs a manager for their data team, seems like a prime opportunity...
2012-09-27
1,551 reads
The Red Gate SQL in the City US tour begins tomorrow in New York City. If you have not registered...
2012-09-27
1,438 reads
A few weeks ago I had a customer engagement, where the customer wanted to implement Nested Partitioned Views. Before we...
2012-09-27
945 reads
A few weeks ago I had a customer engagement, where the customer wanted to implement
Nested Partitioned Views. Before we go...
2012-09-27
3,023 reads
I read yesterday that VMware has updated the “Microsoft Clustering on VMware vSphere: Guidelines for Supported Configurations” KB article linked...
2012-09-27
3,094 reads
There are still seats left on the Learning Tree course – An Introduction to SQL Server event that I will be...
2012-09-27
817 reads
After having too many people ask me what NebraSQL meant (its a play on words - Nebraska+SQL - get it?) I have...
2012-09-27
775 reads
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...
Wa:082374977784 Jl. Palmerah Barat No.38 A, RT.2/RW.3, Grogol Utara, Kec. Kebayoran Lama, Kota Jakarta...
Wa:082374977784 Jl. Jenderal Sudirman Lt Dasar, RT.1/RW.3, Gelora, Kecamatan Tanah Abang, Kota Jakarta Pusat,...
Has anyone ever seen this before? I have sysadmin permission on a server. I...
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get two rows back for the objects, named dbo.beer and etl.beer. Both the tables have identical schemas and are not partitioned. There are 25 rows in dbo.beer and 0 rows in etl.beer. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers