Multiple usage works when used in the same query; multiple queries in the same statement can't re-use it. $0$0 $0 $0This is a big limitation, granted, but the documentation is correct.$0

Visual FoxPro 9.0 SP2CREATE CURSOR - SQL CommandCreates a temporary table that exists until closed. CREATE CURSOR alias_name ...[CODEPAGE=nCodePage] (fname1 cFieldType [(nFieldWidth [, nPrecision])] [NULL | NOT NULL] [CHECK lExpression [ERROR cMessageText]] [AUTOINC [NEXTVALUE NextValue [STEP StepValue]]] [DEFAULT eExpression] [UNIQUE [COLLATE cCollateSequence]] [NOCPTRANS

I have blogged on how to turn on the logging for this utility. http://blogs.msdn.com/b/jason_howell/archive/2012/09/13/enabling-logging-to-troubleshoot-mdsmodeldeploy-exe.aspx There is a configuration file which you can edit to enable the text output, and turn up the logging to the ALL level to see full context of the failure. "C:\Program Files\Microsoft SQL Server\110\Master Data Ser

The minimum supported version for SQL Server 2008 on Windows Server 2012 or Windows 8 is SQL Server 2008 Service Pack 3 or a later. Note that the RTM installation of the product is supported but you need to install the respective service packs after the initial setup is complete. For more information about supported versions of SQL Server on Windows Server 2012 or Windows 8, see http://suppo

Microsoft SQL Server 2005 (release version and service packs) and earlier versions are not supported on Windows Server 2012 or on Windows 8. For more information about supported versions of SQL Server on Windows Server 2012 or Windows 8, see http://support.microsoft.com/kb/2681562 [Minimum version requirements when you install SQL Server on Windows Server 2012 or on Windows 8]ThanksChaitanya

Having the run duration as HHMMSS format seem strange and unintuitive? This would be much better if this was an interger value stored in minutes or seconds which DB Devs, such as myself, can pick up and report from, for example calculate average run time for a job or a particular step. Having to potentially spilt this up into its component parts and apply individual calculations on each part to co

A check on all databases can be done like this in PowerShell: [string]$ServerName = 'SANDY.sqladmin.lan'$Server = New-Object Microsoft.SqlServer.Management.Smo.Server $ServerName$Server.Databases | ForEach-Object { "{0:s} Checking database [$($_.Name)]..." -f $([System.DateTime]::Now) $_.CheckTables([Microsoft.SqlServer.Management.Smo.RepairType]::None, [Microsoft.SqlServer.Manag

Why are the CREATE ROUTE statements in dynamic SQL? Is it just to isolate the USE statements? Or, is there some critical reason?

I am trying to uninstall sql server 2008 and it wont let me get past the setup support rules. says the computer hasn't been restarted. I have tried this many times as well as using SQL Server installation center, receiving the same "Windows restart" status: failed. Esther Fan, MSFT: Thank you for your comments. For these kinds of questions, please try the following forums:MSDN: http://forums.micro

Cluster Node Configuration (Complete)Use the Cluster Node Configuration (Complete) page to specify an existing instance of SQL Server that has been prepared for clustering. Note that Setup operations for SQL Server failover clustering have changed in this release. To install or upgrade a SQL Server failover cluster, you must run the Setup program on each node of the failover cluster. To add a node