SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• selecting only hour and minute from datetime.

  How can I select only Hour and Minute from datetime without any seconds part. I need only 09:43 fro…

  WangcChiKaBastar

  8 replies

  14 years, 4 months ago

  By: prashant-507002

• Script to move a txt file to another folder

  How would I do this. Thats the action eg.RENAME etc.

  kyle.doouss

  3 replies

  14 years, 4 months ago

  By: prashant-507002

• Row to column data show

  Table Name :- DocumentLog Id FieldName FieldValue 1 Name John Lucas 2 …

  prashant-507002

  13 replies

  14 years, 4 months ago

  By: Cadavre

• Not able to access table

  Hi All, Yesterday I execute an update query in a while loop since It is a very huge table. It compl…

  Varun R

  5 replies

  14 years, 4 months ago

  By: Devendrakumar

• backup for system database

  should i take scheduled backup for the system database, and what is the advantages?

  Dhirju

  5 replies

  14 years, 4 months ago

  By: Dhirju

• if more than 10000 txns are coming than that should go to CPU2.

  I have sql server 2008 R2.I have 2 cpu in server I want to set it like this that if more than 10000…

  forsqlserver

  7 replies

  14 years, 4 months ago

  By: Ninja's_RGR'us

• SERVICE ACCOUNT PASSWORD CHANGE ON CLUSTER INSTANCE

  Can some one please provide me the step by step procedure or site. I have the following steps pleas…

  hydbadrose

  1 replies

  14 years, 4 months ago

  By: sean.reece

• SSIS import data

  I have a ssis pacakge, I would like to import two flat source files into one SQL table , I will cal…

  sqlfriend

  3 replies

  14 years, 4 months ago

  By: JonFox

• Stored Proc on name of file

  I am creating stored procedures which down load files, rename files and import files. This is goin…

  kyle.doouss

  3 replies

  14 years, 4 months ago

  By: derek.colley

• How Do I Use Sp_Configure?

  i have to two production server to live it. please help me to configure it using sp_configure.

  Dhirju

  8 replies

  14 years, 4 months ago

  By: Dhirju

• prerequisite for database mirroring

  what is prerequisite for database mirroring in sql server 2008 Enterprise Edition(64 bit) and OS (…

  Dhirju

  1 replies

  14 years, 4 months ago

  By: Ant-Green

• Dplicate records coming from SQL

  Hi, select ixo_rlt_code AS role_name, ind_membership_id_ext AS mbr_id,…

  kiran.rajenimbalkar

  3 replies

  14 years, 4 months ago

  By: kiran.rajenimbalkar

• Backup default folder location in Management Studio

  prolly a stupid question but each time i use management studio to backup a db, i get E:\BACKUP as t…

  jsqldba

  3 replies

  14 years, 4 months ago

  By: jsqldba

• DMV to get all column names in the database along with its table name and column length

  Hello, I have a database xyz and need to get all the table names, its column names and its length. …

  anonymous2009

  1 replies

  14 years, 4 months ago

  By: Ron McCullough

• Data Change Tracing

  Hello, I am a very db knowledgeable developer but not a db developer so forgive me for the simple q…

  nfs_john

  7 replies

  14 years, 4 months ago

  By: craigB-921010