SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• location of stored procedure code in system tables

  I am trying to programatically pull information about the stored procedures of a database to parse …

  chedderslam-700832

  5 replies

  18 years ago

  By: chedderslam-700832

• Why are the table name different from 2000 v 2005 for ASPState DB

  I created both by running installsqlstate.sql, the aspnet_regsql 2000 tables all start with sys and…

  OklahomaSooners

  2 replies

  18 years ago

  By: OklahomaSooners

• To Cascade or not To Cascade...that is the question

  Hi Everyone, I been searching on Cascade Delete on tables...some how I still can not figure out if …

  Jorge.G

  8 replies

  18 years ago

  By: Jorge.G

• Report in Visual Studio.. Case statements results on same line

  I am trying to write a report in VS that will show me information on an account. I wanna know on an…

  Mike Menser

  2 replies

  18 years ago

  By: Mike Menser

• Date to string

  I'm using this CONVERT(VARCHAR, DATEPART(YEAR, CONVERT(DATETIME, Cal.startDate))) +'-'+ CONVERT(VAR…

  bcronce

  2 replies

  18 years ago

  By: bcronce

• How do I create the ASP State Database in SQL 2005?

  I know how to do it in 2000 by running the InstallSqlState.sql statement in 2000's query analyzer, …

  OklahomaSooners

  4 replies

  18 years ago

  By: OklahomaSooners

• Correct me

  Came up with the following script to find differences between 2 tables & here it is..... SELEC…

  upendramkumar

  7 replies

  18 years ago

  By: bledu

• Crystal Reports ActiveX Designer-error Cannot find QE property

  Hi, I have done DTS migration from SQL server 2000 to SQL server 2005. There is One DTS that genrat…

  avinash repe

  1 replies

  18 years ago

  By: bledu

• 2000 DB attached to 2005, SQL Compare, can I put back on 2000?

  Did SQLCompare mess this up? 1) I detached a db from a SQL2000 server 2) I zipped the mdf and ldf 3…

  PhilM99

  5 replies

  18 years ago

  By: ab5sr

• SQL 2005 Upgrade Advisor - do I have to run it locally on server upgraded?

  I have a SQL 2000 instance which I am upgrading to SQL 2005, and I would like to run the Upgrade Ad…

  Marios Philippopoulos

  3 replies

  18 years ago

  By: Marios Philippopoulos

• Query Count Value In a Row

  I have a query that compares two tables which returns a certain value. I would like to count a cert…

  gtan018

  7 replies

  18 years ago

  By: SwePeso

• Any horse racing database users on here?

  Hello, I would like to learn how to use SQL Server 2005 to build a horse racing database. I am 100%…

  csperberg

  3 replies

  18 years ago

  By: csperberg

• Deferrable foreign key?

  Hi I've got a model in which two tables, A and B refer to each other. So I can't insert into A with…

  andre.naess

  11 replies

  18 years ago

  By: Mauve

• Automatic Update on Sql Server 2005 Server Failed for Visual Studio 2005 SP1

  We have two database servers with OS MS 2003 Server and SQL Server 2005 SP2 installed. When we logg…

  j mangual

  3 replies

  18 years ago

  By: Matija Lah

• SP_OA in sql 2005 with mode 80

  i have database in sql 2005 with mode 80 and i have turn on setting for ole automation in surface a…

  Reema-470013

  2 replies

  18 years ago

  By: EdVassie