SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• Can I get the dbname of the active database from a stored procedure in another database?

  Create this SP in some database, in my case "Tools" USE ToolsGO CREATE PROCEDURE [dbo].[foo]ASBEGIN…

  Scott In Sydney

  1 replies

  8 years ago

  By: Sue_H

• Odd Scenario with MSSQL Backup...details inside

  So I was presented with an odd outcome...one which is pretty unique. We have a DB which houses File…

  Leeland

  3 replies

  8 years ago

  By: Mr. Brian Gale

• SSIS Service Account Best Practise

  I have 1 host running 10 SQL Instances. Each SQL Server Service runs under it's own Domain service …

  planetmatt

  1 replies

  8 years ago

  By: Sue_H

• Import multiple excel files in one go

  Hi all, i have around 50+ excel spreadsheets with 1 sheet in each, the same headings but varying am…

  Talvin Singh

  9 replies

  8 years ago

  By: Talvin Singh

• XML index statistics

  Hi , How can I see XML index statistics like other indexes.Using the DBCC SHOW_STATISTICS () I am a…

  dudekula.kareemulla

  2 replies

  8 years ago

  By: Jeff Moden

• Maintenance Plans, I've lost some, where are they?

  I have a SQL Server host running 10 named SQL Instances. Each instance has a Daily Maintenance Plan…

  planetmatt

  1 replies

  8 years ago

  By: Sue_H

• how to take backup databaseobjects(tables scripts,storeprocedure and functions etc) in sqlserver using sql scripts

  Hi All,   I have one doubt in sql server .how to take Script database objects automatical…

  asrinu13

  5 replies

  8 years ago

  By: sturner

• SQL Server 2012 install and tuning checklist

  Hello all,Would anyone have a checklist with some setting tuning and after an initial install for a…

  johnnyrmtl

  2 replies

  8 years ago

  By: johnnyrmtl

• sql data muniplication help

  hi guys hope everyone is well, I need some help I need to manipulate some data so I can produce a …

  imranazam

  3 replies

  8 years ago

  By: Thomas Rushton

• Collect data en show it in a graph

  Hi all, I'm not sure this is the right place for my question, but I'll give it a try: Ik looking fo…

  piet.kouwer

  6 replies

  8 years ago

  By: Jeff Moden

• When a database last accessed (Insert/Update/Delete/Select)

  Hi,I have a request to decommission one of our SQL 2012 server, it has 50 databases on the Instance…

  G Sunny

  2 replies

  8 years ago

  By: Jeff Moden

• SQL Puzzle challenge

  Hi Experts, I am taking a puzzle challenge from a popular website. For the below scenarios,as menti…

  saravanatn

  6 replies

  8 years ago

  By: saravanatn

• Combining data from 2 tables with mostly identical data

  *** Updated with code in Replies***Super Noob here. So sorry if there is already a thread here for …

  sroth 71504

  5 replies

  8 years ago

  By: drew.allen

• Need a .net like function in user defined function of sql server

  I have a .net code which i need to replicate as it is in sql server. Need a same user defined funct…

  nileshahwad88

  4 replies

  8 years ago

  By: Luis Cazares

• CASE Statement

  I need to generate a adhoc report. I need to query a time range(calltime) that is stored as char(5)…

  TryingToLearn

  13 replies

  8 years ago

  By: ChrisM@Work