SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• as a part of side by side upgradation can I upgrade sql server 2000 standard edition 32 bit to sql server 2005 enterprise edition 64 bit

  Hi All, I am going to do side by step upgradation my question is - can I upgrade sql server 2000 …

  krantkk

  4 replies

  15 years ago

  By: Meet George Jetson

• DDL Trigger On Database -Issues

  I'm having problems getting a DB Trigger on DDL to work. From what I've read and discussed with GS…

  YSLGuru

  1 replies

  15 years ago

  By: GSquared

• date format

  TO_DATE('11/17/2005 20:51:27', 'MM/DD/YYYY HH24:MI:SS') above function in Oracle.. wht is the equav…

  BeginnerBug

  9 replies

  15 years ago

  By: JC-3113

• In what circumstances are there no other option than to use cursors?

  I'm studying for the Data Access exam... so I was just wondering if there were ever a case when cur…

  pietlinden

  31 replies

  15 years ago

  By: Johan Bijnens

• Check Available Server Physical Memory

  Is there any way I could script to check the available physical memory for the server running sql 2…

  QQ-485619

  2 replies

  15 years ago

  By: nekonecny

• View - Need Dynamic From Clause for Cross Server Select/Join

  We have different servers/instances for Development and Production AND multiple servers that house …

  tkatona-1119058

  3 replies

  15 years ago

  By: TheSQLGuru

• Question about servers topology

  Hi, We originally had database topology where a master sql server receives all (or at insert 99%) o…

  the_fenix

  5 replies

  15 years ago

  By: David Benoit

• bulk log versus simple

  I am planning to archive and purge a lot of data from a larger[er] production database. I am askin…

  Ellen-477471

  1 replies

  15 years ago

  By: danschl

• Can't create linked server; 32 bit SQL on 64 bit OS with 32 bit odbc

  Hi, I have SQL 2005 Standard sp4 32 bit running on a Windows 2003 R2 64 bit OS. I have a 32 bit odb…

  ipgsql

  2 replies

  15 years ago

  By: ipgsql

• Lost table Identity

  One of my tables no longer auto-increments records that are added. When adding records I am having…

  jack_stockton

  1 replies

  15 years ago

  By: ChazMan

• Select data and update a linked table

  Hi, I am trying to update the table ‘contact’ and in the field ‘temp’ put a value of ‘on course’ wi…

  sc-w

  1 replies

  15 years ago

  By: ChazMan

• Sending automated email from SQL server

  Hello, We have a requirement in which an automated e-mail need to be sent to some email id. In case…

  vishal.shinde

  2 replies

  15 years ago

  By: M&M

• Multi threading in SQL Server 2005

  I am having one procedure, which will extract some 1000's of records from different tables for calc…

  teja.ch

  1 replies

  15 years ago

  By: Lowell

• Need To store true or False

  I have a column name status in mytable. It should have either true or false as a data. for storing …

  Nagaram

  1 replies

  15 years ago

  By: Lowell

• The most bizarre SQL issue ever

  I hope this is in the right section........... This is for build 9.0.4053. I tried to put the follo…

  SQLWannabe

  24 replies

  15 years ago

  By: Ellen-477471