SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Change column in Rows

  Hi , I have a table below where Item is repeated for type Parts and service.    …

  syed_3177

  1 replies

  6 years, 12 months ago

  By: laurie-789651

• bcp with Quote Text Qualifier and Comma Delimiter

  Hello,  I want to export data to an CSV using a comma delimiter.  However, I have a…

  rjjh78

  4 replies

  6 years, 12 months ago

  By: Joe Torre

• How to connect to one database from another database

  Hi ,I have a stored procedure SP1 in database DB1 , schema SCH1.From within this  SP1,  &…

  mahnj18

  1 replies

  6 years, 12 months ago

  By: Joe Torre

• sp_send_dbmail @query fails when there is only one row of data.

  I think I might be going mad, certainly boz eyed.  Grateful for a second pair of eyes & br…

  snomadj

  1 replies

  6 years, 12 months ago

  By: snomadj

• Disable TDE

  Guys, What is the best way to disable TDE. I uncheck the "Set Database Encryption On property" but …

  Amit Lohia

  25 replies

  6 years, 12 months ago

  By: viplove

• SQL Agent Job-Retry

  Dear all, we have sql agent job,the job is schedule everyday @9.30 A.M and @5.30 P.M. @9.30 schedul…

  bala2013

  2 replies

  6 years, 12 months ago

  By: manik_anu

• SQL replication subscription will expire in 4 hours

  Hi, Our monitoring tool throwing below  for SQL 2008 replication in lower environment. Current…

  HBK_4700

  5 replies

  6 years, 12 months ago

  By: Sue_H

• How to deny write permission to a user group for few hours in SQL SEVER

  We have a bunch of queries that we run every month end. These queries store data from our productio…

  saaharjit_24

  1 replies

  6 years, 12 months ago

  By: SQLPirate

• Query to find rows which has replacement character as part of a column string

  Hi All, I have a column in my oracle SQL table where user will city name from the online applicatio…

  krishnamurali2489

  7 replies

  6 years, 12 months ago

  By: Chris Hurlbut

• Is there a way for a program to add/edit data in a SQL Server DB Table that Profiler will not catch

  I'm using Profiler to try and capture when a specific field in a specific table is modified by the …

  YSLGuru

  4 replies

  7 years ago

  By: YSLGuru

• CrossTab in SQL

  Hi all,I have two queries in access* Collect data from which two text boxes supply the date range c…

  barry.nielson

  5 replies

  7 years ago

  By: Jeff Moden

• Log ship Files to diffrent drives

  Hi, Haven't been able to work this out, if I create a log shipped Database I have no problem having…

  Edward-445599

  1 replies

  7 years ago

  By: Sue_H

• remove Identity from a column

  Hi Dudes, I have a Table Which has a column that is set to identity by mistake and it is on my cust…

  ashkan sirous

  21 replies

  7 years ago

  By: Orlando Colamatteo

• how to decide which isolation is better while implement scripts in sql server

  Hi I have one doubt in sql server . how to choose which isolation level is better while implement s…

  srinudw88

  1 replies

  7 years ago

  By: Joe Torre

• Indexing a character column

  Dear All,Can anybody with a good web link or some material on 'Indexing on Numeric column types. I …

  Arsh

  3 replies

  7 years ago

  By: Grant Fritchey