SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• SSIS - handling errors within a for-each loop container

  Hello, I have an SSIS package with a for-each loop container. The loop queries records from a data…

  jeff_sherian

  6 replies

  11 years, 3 months ago

  By: gireesh585

• How many max number of distributors can a subscriber / Publisher have?

  How many max number of distributors can a subscriber / Publisher have? Thanks.

  SQL_Hunt

  2 replies

  11 years, 3 months ago

  By: SQL_Hunt

• Cannot find the executing stored procedure

  I ran the following query select o.name, last_execution_time from sys.dm_exec_procedure_stats ps i…

  Guras

  7 replies

  11 years, 3 months ago

  By: Guras

• Job schedule to avoid one weekly time window

  Hello, I have a SQL Agent job that needs to run every 5 minutes throughout the week but not run dur…

  Ken Davis

  2 replies

  11 years, 3 months ago

  By: Ken Davis

• Statistics hasn't been updated

  I ran Glenn berry's query and saw I have a big table 40 million rows. that has only 1 clustered ind…

  Tac11

  3 replies

  11 years, 3 months ago

  By: Tac11

• How to hide/disable the menus New Database, Restore Database in SQL Server Management Studio

  Hi, I want to force my SQL Server developers to run a script to create a new database and restoring…

  Mohan G

  11 replies

  11 years, 3 months ago

  By: Jeff Moden

• Reading XML performance - openxml or xquery

  My original post didn't get the responses I was looking for. So here's an example of the performan…

  N_Muller

  7 replies

  11 years, 3 months ago

  By: mister.magoo

• Split Columns of Months into Columns of Weeks

  Hi all, 1st time asking a question here (usually most things I need to know have been answered in o…

  jesse.owen

  14 replies

  11 years, 3 months ago

  By: ScottPletcher

• Change From Single Variable to Table Variable

  Any tips on how to modify the code below would be greatly appreciated. The transaction below takes …

  scotsditch

  2 replies

  11 years, 3 months ago

  By: ScottPletcher

• Interesting Issue

  Ran into a small issue with SSRS today. I haven't really worked on the backend of SSRS too much, bu…

  xsevensinzx

  15 replies

  11 years, 3 months ago

  By: xsevensinzx

• How to define Production, Non-Production and Development

  Hi Not sure which forum to post this question but here goes. My company has a stand alone sql insta…

  jdbrown239

  4 replies

  11 years, 3 months ago

  By: Gail Shaw

• build a stored procedure using multiple row/fields from a table

  This is an oversimplified example of something I'm trying to build. The real #Dynamic table might …

  texpic

  1 replies

  11 years, 3 months ago

  By: stevenb 14609

• Provider Parameters MSDASQL - HELP

  Hi All, It's known the command [EXEC master.dbo.sp_MSset_oledb_prop N'MSDASQL', N'AllowInProcess', …

  anderson.rsantana

  4 replies

  11 years, 3 months ago

  By: mister.magoo

• Wow!!! I didn't know that could be done - Datetime Calculations

  All, I have been programming in T-SQL for a while. I still love what I do since there is still so…

  aochss

  12 replies

  11 years, 3 months ago

  By: Charles Kincaid

• SP_xml_preparedocument is not available in SQL 2008 R2

  Hi There SP_xml_preparedocument is not available in SQL 2008 R2, is there other procedure i can us…

  fawad.majid

  1 replies

  11 years, 3 months ago

  By: John Mitchell-245523