SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• Database in recovery due to insuffcient space

  Hi Experts, One of our DB is in recovery state due to insufficient space in drive where the log fil…

  VastSQL

  12 replies

  12 years ago

  By: enriquemallon

• Re-organizing Full-Text catalog

  Hi All, I am in a dilemma if I should reorganize or rebuild a full text catalog. My application own…

  indianscorpion29

  4 replies

  12 years ago

  By: indianscorpion29

• Indexed view (MView) on replicated server is very very slow

  Hi, all That what we got, we had very nice tuned MView defined on Server01 against tables in dbA…

  mario17

  4 replies

  12 years ago

  By: mario17

• Generate Triggers for Newly created tables

  Hi All, I have many new tables for which i need to write Insert,Update and delete triggers manually…

  vijay.singh 14112

  1 replies

  12 years ago

  By: Jeff Moden

• SP2 install and 'Check Files In Use'

  Hi I am installing SQL Server 2012 Service Pack2. The OS is Windows 2012R2. When I go through the …

  kathy.plamann

  1 replies

  12 years ago

  By: Maddave

• Conversion Failed

  Hi, I need to find which SQL Agent job is created when we subscribe SSRS report. SELECT …

  ramana3327

  2 replies

  12 years ago

  By: ramana3327

• Generate Scripts Result in a order of tables and then stored procedures in SQL Server

  Hello All, I have created one table and one stored procedure for to insert/delete/update the data i…

  Ramchand

  6 replies

  12 years ago

  By: Sean Pearce

• Sql Server Agent Job

  Hi, How can we find the recent modification to a job. I saw there is two different schedules for on…

  ramana3327

  3 replies

  12 years ago

  By: sqlsurfing

• SSMS 2012 appears to be very buggy

  Is it me or does anyone else out there feel like SSMS for 2012 is buggy even after the latest SP I …

  Mr. SQL

  4 replies

  12 years ago

  By: Alan Burstein

• SSIS for each loop

  I have just set up an SSIS package similar to this http://sql-bi-dev.blogspot.co.uk/2010/07/dynamic…

  SQLAssAS

  3 replies

  12 years ago

  By: SQLAssAS

• Creating a view which access objects in another database (without giving permissions to underlying base tables)

  We are running SQL Server 2012 on Windows 2008 Server. In one database, we would like to create a v…

  HookSQLDBA7

  1 replies

  12 years ago

  By: John Mitchell-245523

• View Definition?

  Hi Everyone, I have a Question i.e, I want to create a login with some restriction like the followi…

  Chowdary's

  3 replies

  12 years ago

  By: Chowdary's

• Deadlock Analysis from SQL trace file.

  HI, I am getting deadlock in my production, i was taken deadlock information from trace file , i fo…

  PRAMANA.DBA

  5 replies

  12 years ago

  By: PRAMANA.DBA

• Deadlock file location

  Hi All, I have enabled 1222 and 1204 trace and restarted sql server. then i have replicated deadlo…

  PRAMANA.DBA

  10 replies

  12 years ago

  By: Sean Pearce

• Pass entire where sentence to a store procedure

  Is it possible to pass entire where sentence to a store procedure? From app, I'll generate a where …

  adonetok

  8 replies

  12 years ago

  By: Sean Pearce