SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• What command logshipping.exe uses for taking log backup?

  If anybody knows, please help.

  Ganeshkumar005

  1 replies

  13 years, 9 months ago

  By: Ganeshkumar005

• Tran Log VLF 's - how exactly do they work?

  Lets say i have a tran log with 4 VLF's. 1st one is full, with no open transactions. 2nd one is hal…

  winston Smith

  1 replies

  13 years, 9 months ago

  By: Suresh B.

• count the number of rows that select query is going to select

  Hi DBA's can we find the count of rows that a select query is going to select before the query is e…

  SQListic

  2 replies

  13 years, 9 months ago

  By: Richardyager

• Please help!!! XACT_E_CONNECTION_DENIED!!!!

  Msg 8510, Level 20, State 3, Line 17 Enlist operation failed: 0x8004d01d(XACT_E_CONNECTION_DENIED).…

  matthew90510

  5 replies

  13 years, 9 months ago

  By: DBA328

• backup problem

  hello I have very wired problem I schedule my back up at 3:00 AM everyday.and it store backup to d…

  surma.sql

  10 replies

  13 years, 9 months ago

  By: surma.sql

• Problem importing data in SSMS

  I need to import a .xls file in to SQL server. When I go into task/import from the DB I get this er…

  Quinn-793124

  3 replies

  13 years, 9 months ago

  By: Quinn-793124

• Is it a good practice to maintain the data in a separate table from the task table?

  In my application there is a module which displays info by reading from a table. This info can be e…

  vinodpsg

  1 replies

  13 years, 9 months ago

  By: Evil Kraig F

• Automated Database Extraction with validation

  First off let me preface this with I'm not a DBA, I'm decent with databases and I sling some code o…

  databit-748427

  7 replies

  13 years, 9 months ago

  By: MyDoggieJessie

• Merge & Transactional Publications on the same DB

  Hello, I've setup a Merge Publication and Subscriber between Server A (Publisher) and Server B (Sub…

  Pete-L

  4 replies

  13 years, 9 months ago

  By: anandvin

• Date format question

  Hi, For "07/13/2012 1:06:12 AM" --> I am getting "2012-07-13T01:06:12.000-04:00" How can I …

  gsd1

  9 replies

  13 years, 9 months ago

  By: Lynn Pettis

• Drop SP without USE <database>

  Is there a way to drop a stored procedure without first running USE <database> to change the …

  Sven_Lowry

  2 replies

  13 years, 9 months ago

  By: Lowell

• Need help writing an update (or insert maybe) query

  I have a table called dbo.Incidents and i need to get the time difference in seconds between the fi…

  jonathanknowles

  2 replies

  13 years, 9 months ago

  By: jonathanknowles

• Providing datasets to customers - is replication the best approach? What is most commonly used?

  Our product has one OLTP MSSQL database per customer, all using the same schema. We are in the earl…

  dev_etter

  4 replies

  13 years, 9 months ago

  By: dev_etter

• Record linkage advice required– Long read (YOU HAVE BEEN WARNED!)

  Hi, I have the following table structure: create table dbo.PreMerge ( master_idint, Titlevar…

  Abu Dina

  22 replies

  13 years, 9 months ago

  By: ChrisM@Work

• use xp_cmdshell in OPENROWSET

  Hi, I am trying to run below query on sql server 2005. SELECT * FROM OPENROWSET ('SQLOLEDB','SERV…

  nzhang6666

  5 replies

  13 years, 9 months ago

  By: nzhang6666