SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Create a sql server 2005 database in a sql server 2008 server

  Hi all, What I would need to know is if it is possible to create databases with a format of an olde…

  dambuster

  2 replies

  16 years ago

  By: Lowell

• Comparison of real values

  Hi, I have to compare two real values, but results are not desirable when I am comparing them, even…

  ruchi-761283

  1 replies

  16 years ago

  By: nigel.

• Definition of Session and Connections

  I am looking for the definition of a session and connections in SQL 2005? I have looked in the SQL …

  Mark Johns-446485

  1 replies

  16 years ago

  By: Paul White

• Get Latest Records

  Hi All, i have a table which contains details with respect to date and time. the data in date colum…

  imfairozkhan

  4 replies

  16 years ago

  By: imfairozkhan

• Partition By and Count

  Hi, it is very difficult to make sql scripts to count Flag with making sequences. Oracle has its la…

  ohio_bear_1234

  2 replies

  16 years ago

  By: ohio_bear_1234

• Filling in the gaps between dates

  All, Please see the below query. I'm trying to run a report of how many users cancelled their sub…

  LeDeau

  1 replies

  16 years ago

  By: Dave Ballantyne

• Each GROUP BY expression must contain at least one column that is not an outer reference.

  Hi There, Can someone please tell me why I get this error message: Each GROUP BY expression must co…

  paula_sql

  7 replies

  16 years ago

  By: OomBoom

• T-sql query and tempdb growth

  Our developer wrote a query that chews up tempdb space (700GB) before our maximum limit kils the pr…

  Barkingdog

  1 replies

  16 years ago

  By: Gail Shaw

• MCITP

  Hi All, I want to do certification in MS SQL Server 2005. Can any one give an idea about how to pre…

  sql-1017511

  3 replies

  16 years ago

  By: SQLBOT

• SQL 205 Views

  ALTER VIEW [dbo].[vFrmMainCboMessageItem] AS SELECT TOP (100) PERCENT itemId, messageTypeId, se…

  jdhouse

  7 replies

  16 years ago

  By: jdhouse

• Average Number of Months Between Events?

  Looking for some help here. I have a table that consists of Month/YR as columns and ID numbers as …

  JP Dakota, PRC

  8 replies

  16 years ago

  By: JP Dakota, PRC

• A transport-level error has occurred when sending the request to the server.

  windows 2003 server enterprise x64 Sp2 (clustered w/ active/passive) sql server 2005 Sp2 managed to…

  Leo Leong

  5 replies

  16 years ago

  By: manoharan.naveen

• One Stored Proc, Two Reports

  We have SSRS installed and are working on two reports that basically use the same stored proc. My …

  jim_piller

  2 replies

  16 years ago

  By: jim_piller

• Scheduled jobs say completed but nothing happened

  When i run jobs manually, they work correctly, sending the final result to a table in a database. B…

  PK-669256

  1 replies

  16 years ago

  By: Steve Jones - SSC Editor

• script job as sql, .... and back again.

  I understand how to script a job that I have created in SQL server agent/jobs as an SQL statement, …

  tonyr-912197

  4 replies

  16 years ago

  By: tonyr-912197