SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Trigger Usage

  Hi, I have to create audit log feature and i am aware of creating trigger against the table to get …

  born2achieve

  8 replies

  12 years ago

  By: born2achieve

• derived column date in ssis

  Hello In derived column, I have Date column named (AS_DATE) and i used (DT_DBDATE)(GETDATE) in der…

  patla4u

  5 replies

  12 years ago

  By: jerrylcarroll

• Restoring an database schema only

  Hi I have a requirement to restore one of our production databases minus the data. I have on my per…

  PearlJammer1

  3 replies

  12 years ago

  By: PearlJammer1

• How to Get data from Table2 instead of Table 1?

  Kindly help me my requirement? I have two tables and similar column like (year, week, day, and shif…

  manavairajan

  3 replies

  12 years ago

  By: Jeff Moden

• SQLServer 2005 to Oracle 10g migration

  I have 4 databases in SQLServer 2005 and in Oracle there are 28 tables and all the fields are match…

  joshtheflame

  4 replies

  12 years ago

  By: joshtheflame

• Turning on trace flag 1222 for deadlocks

  Does anyone know if there is any noticeable performance impact by turning on trace flag 1222?

  mike l

  8 replies

  12 years ago

  By: Grant Fritchey

• send to email based on output?

  Hi What I would like to do is email users who end up on a report for example if a user has not had …

  jbalbo

  3 replies

  12 years ago

  By: MyDoggieJessie

• Sql Mail Procedure

  Hi All, Im making an attempt at this for the first time through Visual Studio, I am not getting an …

  Sifu A

  2 replies

  12 years ago

  By: Sifu A

• ODBC error calling executable from a stored procedure

  Hello, I have an executable created with VB.Net that opens an Access database and executes some que…

  mr-967650

  3 replies

  12 years ago

  By: x

• I need help getting four queries into one

  I have four queries that i need returned onto a single row. I have tried to come up with an inline …

  rob_bradley

  4 replies

  12 years ago

  By: rob_bradley

• Index physical stats dmv

  how to get obj id, index name, clustered\heaponclustered, filegroup, Percent fragmentation in a sin…

  balasach82

  6 replies

  12 years ago

  By: SQLBuddy123

• Script to list all tables and columns involved in Stored Procedure

  If anyone can provide script to list all the tables and columns involved in a Stored Procedure woul…

  PJ_SQL

  12 replies

  12 years ago

  By: Lowell

• move datafile to a different disk

  Guys, I have a requirement to move one of the datafiles (140gb) to a different disk. Is there anyth…

  SQL!$@w$0ME

  5 replies

  12 years ago

  By: SQL!$@w$0ME

• Snapshot replication

  Using replication, the published tables can not be altered, so we can't add a field to a table. Why…

  SQLAssAS

  16 replies

  12 years ago

  By: SQL Severe DBA

• SQL Server has encountered x occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [E:\DATA\xxxx.mdf]

  This past Saturday I have a log full of these errors. Customers were reporting the software taking …

  SQLChao

  3 replies

  12 years ago

  By: lptech