SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• SP_Send_DBMail to recipient called from a table

  I am relatively new to programming procedures, but want to program one that will execute the sp_sen…

  reardond

  2 replies

  11 years, 2 months ago

  By: reardond

• Looking for advice on DATE_FORMAT()

  SELECT c.cust_fullname AS Name, c.cust_membership_id AS Account, t.c_amount …

  chef423

  4 replies

  11 years, 2 months ago

  By: chef423

• Need a query to delete pk.

  I have a table sample in which sample_uid is primary key another table i have is test which contain…

  mcfarlandparkway

  1 replies

  11 years, 2 months ago

  By: Ed Wagner

• Row Size Limitation

  Hi there - I keep getting the following error; Msg 511, Level 16, State 1, Line 103 Cannot create a…

  arrjay

  35 replies

  11 years, 2 months ago

  By: Sean Lange

• Is their a way to get metadata info about views

  I've been breaking my poor head over the following problem,I want to show certain meta data of all …

  Resender

  4 replies

  11 years, 2 months ago

  By: Resender

• Change rowns to columns

  Hi I have this query: select descr_rep_fiscal, metodoctb, dt_emissao, count (metodoctb) as ocorrenc…

  river1

  9 replies

  11 years, 2 months ago

  By: Jeff Moden

• app to match clients in the different databases

  Hello We have multiple databases with tables with client's data, name/dob/ssn. We are looking for a…

  onixsoft

  4 replies

  11 years, 2 months ago

  By: onixsoft

• How to find unused stored procedures in sql server

  How to find unused strored procedures in sql server, one my custeromer asking need to delete unused…

  solomon.jernas

  2 replies

  11 years, 2 months ago

  By: Stamey

• Enable CDC on hundreds of databases

  Hi, we host somewhere in the range of 500 - 1000 databases on a SQL 2008 and we're thinking of impl…

  tomes12

  3 replies

  11 years, 2 months ago

  By: kevaburg

• Table Execution taking time?

  Hi Everybody, I have 65 tables in my DB,In that one of the table is taking time to execute ,Yesterd…

  Chowdary's

  3 replies

  11 years, 2 months ago

  By: Gail Shaw

• Is Alter database minimally logged in bulk recovery mode?

  Hello, If I alter column sizes on table in a database whilst in bulk logged mode, will the transact…

  Duran

  3 replies

  11 years, 2 months ago

  By: Duran

• Replication Issue

  Hi All, I have an issue with the Replication … It shows up error saying :” Replication – Replicatio…

  WhiteLotus

  1 replies

  11 years, 2 months ago

  By: WhiteLotus

• sql update query with concatation on value? Is this possible

  I'm trying to concatanate values on a table update from another table. DECLARE @tbl_to TABLE(col1 I…

  bugg

  2 replies

  11 years, 2 months ago

  By: bugg

• Service pack 3 for SQL Server 2008 R2

  Is service pack 3 is available for SQL server 2008R2 version? If it does then can you send me the l…

  hydbadrose

  3 replies

  11 years, 2 months ago

  By: Luis Cazares

• The database cannot be opened because it is version 706. This server supports version 661 and earlier

  Today I was trying to attach a database in SQL server 2008 R2. I got an error while attaching datab…

  enriquemallon

  2 replies

  11 years, 2 months ago

  By: Gail Shaw