SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• System Databases and DBPro........

  I have a database project I am trying to create. It references several objects in MSDB and one in …

  Angelindiego

  1 replies

  14 years, 7 months ago

  By: GSquared

• When does sql 2008 release "memory"?

  We run a monthly process that causes sql to use about 11GB of RAM. The remainder of the month the s…

  Barkingdog

  6 replies

  14 years, 7 months ago

  By: sam.alexander

• Dont see Transaction log shipping option under properties under database properties.... why?

  Hi, All Dont see "Transaction log shipping" option under properties under database properties.... w…

  harita

  9 replies

  14 years, 7 months ago

  By: harita

• CONCATENATE not working

  Hi, can someone please help me with this syntax, it is not working in sql server LEFT(TRIM(CONCATEN…

  Krasavita

  13 replies

  14 years, 7 months ago

  By: GSquared

• View vs Ad-hoc T-SQL

  Hello, I have a view that basically joins two tables of > 1million rows. Example Only: create VI…

  uncle_boris

  14 replies

  14 years, 7 months ago

  By: Gail Shaw

• error '3146' when importing file using access as front end into SQL Server

  Hi We have access serving as front end connecting to SQL server. Our SQL Server was upgraded from …

  samdp0817

  1 replies

  14 years, 7 months ago

  By: Sean Lange

• Visual Studio deploy of views using OPENQUERY via linked server with sqlcmdvar reference causing syntax error.

  When building a Visual Studio 2010 database project, having views that use OPENQUERY (instead of 4-…

  Drikus Roux

  2 replies

  14 years, 7 months ago

  By: Drikus Roux

• backup files delete - script

  Hi, I need to clean backups and the condition is to delete all bak files in the folder but keeping …

  ALIF-662928

  4 replies

  14 years, 7 months ago

  By: ALIF-662928

• using local variables in place of passed parameter

  I have run across several scenarios where my Stored Procedures, with a parameter, take an abnormal …

  jch50a

  3 replies

  14 years, 7 months ago

  By: jch50a

• SSRS - How to eliminate blank page?

  I have requirment to add 3 sub reports to existing report Needs to make visible true / false based…

  visual.prabu

  1 replies

  14 years, 7 months ago

  By: Perry Whittle

• Convert Rows Into Column

  Hi All, i have a requirement in which i have to convert my rows into column with some specific cond…

  ankur11june

  3 replies

  14 years, 7 months ago

  By: Arjun Sivadasan

• Several Parent Procs running the same child Proc

  I have 4 parent stored procedures that will be executing the same child stored procedure. These par…

  Khades

  1 replies

  14 years, 7 months ago

  By: colin.Leversuch-Roberts

• Certification - 70-450

  Hi, I just passed my 70-432 exam yesterday. I want to start preparing for the 70-450 exam ASAP. I r…

  pierrelessing

  2 replies

  14 years, 7 months ago

  By: Suresh B.

• Merge operator and transactional replication

  Hi, Just was wondring if there are any potential problems in using Merge operator to load data into…

  Roust_m

  2 replies

  14 years, 7 months ago

  By: Arjun Sivadasan

• DBMIRROR_SEND Wait type

  Hi I have a slow perfromance issue on one of my Production SQL Instances. The only thing that I can…

  _Beetlejuice

  2 replies

  14 years, 7 months ago

  By: HowardW