SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• slow sql server machine

  Hello, We have a sql server machine with many databases. These databases are big and a few of the t…

  arkiboys

  7 replies

  11 years, 11 months ago

  By: Grant Fritchey

• Need to upgrade SQL Server 2012 Standard edition to Enterprise edition.

  Hi, we need to upgrade from a SQL Server 2012 Standard installation to SQL Server 2012 Enterprise …

  bala2

  7 replies

  11 years, 11 months ago

  By: Grant Fritchey

• How to View OR Retrieve all the tabs in SQL.

  SQL query windows saves all the tabs in numerical sequence after you close each window. SO for…

  Port1433

  11 replies

  11 years, 11 months ago

  By: ssms-man

• SSIS - create a script task programatically (the binary code for the script is not found)

  Hi, I wrote a script task that´s build a SSIS Package dynamically with a Script Task. When I open t…

  marcelo.negrisoli

  4 replies

  11 years, 11 months ago

  By: marcelo.negrisoli

• How to create a SQL 2012 Failover cluster using VMs?

  Hi thanks before everything!, I have the following question that I hope you can oriented me: How to…

  APA0876

  10 replies

  11 years, 11 months ago

  By: Perry Whittle

• many to many relationship

  Hi, why do we need a junction table in a many to many relationship? Why can't everything be in jus…

  aajavaherian

  14 replies

  11 years, 11 months ago

  By: webrunner

• Cannot connect with read only intent when using listner name

  Hi All, I have an issue when connecting with applicationIntent=readonly when using Listener name. I…

  Roy Ernest

  3 replies

  11 years, 11 months ago

  By: Perry Whittle

• Changing Availability Group

  Hi Experts, How can we change the backup replica in Always on Cluster. I am not able to take backup…

  VastSQL

  7 replies

  11 years, 11 months ago

  By: Perry Whittle

• Long delay beween job start and actual package execution.

  Hello I have problems sometimes with a package. There is and SQL Agent job that starts a package (f…

  olegasdo

  3 replies

  11 years, 11 months ago

  By: olegasdo

• Monitoring Clustered Server

  Hi All, Could you please let me know what are the events to be monitored for a Active/Passive Clust…

  Satheesh E.P.

  4 replies

  11 years, 11 months ago

  By: Satheesh E.P.

• Disk Space required for Express edition engine vs Developer

  We have a debate in my dev team on what edition of SQL should be installed on a VM template for new…

  joshcsmith13

  2 replies

  11 years, 11 months ago

  By: joshcsmith13

• Pull the string inside the stored procedure definition

  In the below procedure definition, i need to find a way parse the definition and get the list of pl…

  vamsye

  14 replies

  11 years, 11 months ago

  By: Sean Lange

• Assign create stored procedure permissions

  Only to a specific schema? Can this be done? Thanks, DK

  DKlein

  5 replies

  11 years, 11 months ago

  By: DKlein

• Differences between SQL 2012 AND SQL 2008R2

  Can anyone expalin the Differences between SQL 2012 AND SQL 2008R2 ?

  Arjun SreeVastsva

  13 replies

  11 years, 11 months ago

  By: Koen Verbeeck

• get view definition using SQL_Modules with linebreaks so that different lines can be inserted as different records into a table

  SELECT [DEFINITION] FROM SYS.SQL_MODULES WHERE [OBJECT_ID] = OBJECT_ID(@OBJECTNAME) I know I can us…

  vamsye

  1 replies

  11 years, 11 months ago

  By: Sean Lange