MDS Error: “The status of the specified batch is not valid”
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,368 reads
Blog Posts
Nested Partitioned Views
A few weeks ago I had a customer engagement, where the customer wanted to implement Nested Partitioned Views. Before we...
2012-09-27
933 reads
Nested Partitioned Views
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,012 reads
No more NebraSQL
After having too many people ask me what NebraSQL meant (its a play on words - Nebraska+SQL - get it?) I have...
2012-09-27
767 reads
Off to the Center of the Universe
“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,695 reads
SQL in the City US tour begins tomorrow #sqlcity
The Red Gate SQL in the City US tour begins tomorrow in New York City. If you have not registered...
2012-09-27
1,433 reads
SQL Saturday 151 Interview: Stacia Misner
Hello Dear Reader SQL Saturday 151 is just around the corner. If you haven't registerd there is still time to...
2012-09-27
1,722 reads
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,755 reads
SQL Server 2012 AlwaysOn now officially supported by VMware
I read yesterday that VMware has updated the “Microsoft Clustering on VMware vSphere: Guidelines for Supported Configurations” KB article linked...
2012-09-27
3,088 reads
The State of Microsoft Self-Service Reporting
(article published on the MVP Award Program Blog) I really enjoy this topic. One of the reasons, I suppose, it’s...
2012-09-27 (first published: 2012-09-25)
2,750 reads
Blogs
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Creating a SQL Stored Procedure to Load a SCD2
By DataOnWheels
This is a blog that I am writing for future me and hopefully it’ll...
Funny Money: #SQLNewBlogger
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Forums
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometry
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
Running SQLCMD II
Comments posted to this topic are about the item Running SQLCMD II
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers