Display: Cloud | List
Most Popular Tags
Results (278 total) All > sql (x)
re multiple usage (Using Common Table Expressions)
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
Last modified by teljj001 on 11/2/2010 5:58:00 AM
Tags:  a  are  command  contentbug  create  cursor  easy  for  great  in  instead  later  life  like  made  my  of  programming  sql  such  tables  temp  there  use  vfp  why
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
Last modified by Microsoft on 7/11/2007 8:39:11 PM
Tags:  a  any  command  create  cursor  did  find  for  great  i  in  later  like  not  one  sql  temp  this  to  use
Turn on logging in case of failures deploying (Deploy a Model Deployment Package by Using MDSModelDeploy)
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
Last modified by Jason H (HDInsight) on 9/13/2012 10:29:47 PM
Tags:  css_update  error  logging  mds  sql
SQL Server 2008 on Windows Server 2012 or Windows 8 (Hardware and Software Requirements for Installing SQL Server 2008)
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
Last modified by Chaitanya Medikonduri on 9/10/2012 7:58:02 AM
Tags:  2008;  2012;  8  server  server;  sql  windows
SQL Server 2005 on Windows Server 2012 or Windows 8 (Hardware and Software Requirements for Installing SQL Server 2005)
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
Last modified by Chaitanya Medikonduri on 9/10/2012 7:49:39 AM
Tags:  2005;  2012  8;  server  sql  windows
run_duration (sysjobhistory (Transact-SQL))
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
Last modified by WillRelf on 3/23/2012 12:01:16 PM
Tags:  agent  sql
PowerShell example (Database.CheckTables Method (Microsoft.SqlServer.Management.Smo))
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
Last modified by Thomas Lee on 1/27/2012 8:13:35 PM
Tags:  code  powershell  sql
CREATE ROUTE Dynamic SQL? (Lesson 2: Creating the Initiator Database)
Why are the CREATE ROUTE statements in dynamic SQL? Is it just to isolate the USE statements? Or, is there some critical reason?
Last modified by JediSQL on 1/11/2012 12:17:59 AM
Tags:  broker;  create  dynamic  route  service  sql
Can't uninstall SQL Server 2008 (Initial Installation (SQL Server 2008))
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
Last modified by 樂天 on 3/18/2012 5:54:25 PM
Tags:  sql
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
Last modified by Microsoft on 7/12/2011 5:55:57 PM
Tags:  instance  sql
Page view tracker