SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Mdf format file

  Hello everyone, Could anyone out there help me? How to open .mdf format file?

  darin 59447

  1 replies

  7 years, 7 months ago

  By: Thom A

• IF Statement for sending email via Database mail

  Depending on whether the couter is 0 or above 0 then I want a different email sending. Can anyone h…

  Alasdair Thomson

  3 replies

  7 years, 8 months ago

  By: SeaQL17

• Getting "Syntax error in TextHeader of StoredProcedure" error

  I'm tried to edit one of our stored procedures in SSMS. When I attempt to open it, I get the follo…

  Rod at work

  16 replies

  7 years, 9 months ago

  By: daveh0ward

• When to mess with CPU affinity?

  I took some stats away from PerfMon and did some analysis - I've got a quad-core, hyperthreaded (2x…

  derek.colley

  17 replies

  7 years, 9 months ago

  By: KerriLK

• SQL code to retrieve rows

  Hi all, thanks for any help given.I have a table with two columns and Date2... e.g. DateTime1&nbs…

  SIJCOOKE

  3 replies

  7 years, 10 months ago

  By: drew.allen

• SQL 2005 (SP4) Standard edition upgrade to Enterprise edition failing

  Hey Guys, I was upgrading SQL Edition one of our development SQL server running on Windows 2008 R2 …

  mayur.sidhpura

  1 replies

  7 years, 10 months ago

  By: alnor

• convert timestamp to varchar

  hi... how can i convert a timestamp field to varchar? thanks....

  Helical Johan

  10 replies

  7 years, 10 months ago

  By: david.holley

• When exporting data from SQL server 2005 to csv files, columns do not align properly.

  Hi All, I want to migrate data from SQL server 2005 to Company owned database. I created csv files …

  sayli 5771

  6 replies

  7 years, 10 months ago

  By: MMartin1

• passing GUID to a stored procedure

  Hi All, I am trying to pass a GUID to a stored proc. USE [dbsccct] GO DECLARE@return_value int EX…

  sandygem2k

  8 replies

  7 years, 10 months ago

  By: Prometheus112

• SSMA Error: Unable to transfer display properties for column A because corresponding target object does not exist.

  Hey everyone, can someone provide some light on this error, or how to go about troubleshooting? I a…

  Rango

  4 replies

  8 years ago

  By: Rango

• How To Get System Uptime via T-SQL

  Anyone know if its possible and if so how to get the system/sever uptime using T-SQL? I found a ni…

  YSLGuru

  12 replies

  8 years ago

  By: Lowell

• Find all queries which use a perticular index.

  If i want to delete my IX_Unused_Index but before that i want to identify which queries will be af…

  bhushanvinay

  9 replies

  8 years ago

  By: stephen.kratowicz

• Replication between SQL 2005 and DB2

  I am trying to setup transactional replication between SQL 2005 and DB2 on MVS platform. I am using…

  SQL ADMIN 79

  9 replies

  8 years ago

  By: v_nikonor

• Delete files that are older than 7 days

  I have a folder in d drive called Archive (d:\archive) which stores all data load files. The name…

  QQ-485619

  18 replies

  8 years ago

  By: Ed Wagner

• SSIS to Oracle

  Dear all, Kindly need advice.. I want to dts table from oracle to sql with ssis. Total 302 rows. wh…

  Deny Christian

  2 replies

  8 years ago

  By: Deny Christian