SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Error(Executing SQL directly; no cursor.) -- New Sql Server JDBC driver 2.0

  Hi, We recently installed the new JDBC driver 2.0 because we were unable to connect to Sql Server …

  abba-602531

  4 replies

  15 years, 2 months ago

  By: shr_khr

• Problems adding Nodes to SQL 2005 Cluster

  I am attempting to add 2 new nodes to our existing 2 node cluster. We have a total ot 8 virtual ser…

  Carl Sorgenfrie

  1 replies

  15 years, 2 months ago

  By: EdVassie

• Trace table inserts/updates

  Hi, I am planning to write a trace to capture the trace for inserts/updates happening in sql-server…

  Baskar B.V

  7 replies

  15 years, 3 months ago

  By: Baskar B.V

• Making SQL Agent re-execute job upon failure

  Hi, I have a job that fails every now and then because of the system timing out due to various re…

  DataGuy

  1 replies

  15 years, 3 months ago

  By: Grant Fritchey

• Help needed!!!

  i wrote this query: SELECT PlayerID,Username FROM dbo.Players WHERE PlayMode='p' and CasinoID=5 and…

  rea_wag

  8 replies

  15 years, 3 months ago

  By: rea_wag

• SQL 2005 Blocking by session id -2

  We run Biztalk on SQL Server 2005 cluster. While monitoring servers via Spotlight, I noticed a lot …

  sqladdict

  1 replies

  15 years, 3 months ago

  By: sqladdict

• How to Handle the white space in report

  Hi MSBI stars Here i have problem with reports.Problem is i have 15 displayed columns, in that 5(pr…

  kpsr_kpsr 63487

  1 replies

  15 years, 3 months ago

  By: Kari Suresh

• checking to see if I can change from 8.0 to 9.0 compatibility

  I have inherited a database in 8.0 compatibility and I'm trying to see if there is a way I can easi…

  murray50

  3 replies

  15 years, 3 months ago

  By: RP_DBA

• How to create a new Database and copy data from existing DB

  Hi, On daily basis I want to create a Database and after that I want to copy data from another data…

  siva.vgv

  1 replies

  15 years, 3 months ago

  By: parthenitin

• If I install KB970892 security update, will the SQL Server instance version changes from 9.0.4035 to new version? or only cumulative update changes the version

  If I install KB970892 security update, will the SQL Server instance version changes from 9.0.4035 t…

  montril2121

  1 replies

  15 years, 3 months ago

  By: george sibbald

• dbmail not being sent from job

  I'm trying to setup my db backup job to send me an email when the job fails. I setup db mail and it…

  SQL_NuB

  2 replies

  15 years, 3 months ago

  By: SQL_NuB

• Error during the notification via email for a SQL Server Agent job

  Hi. I have a SQL Server Agent job on a SQL Server 2005 RTM installation. I have enabled the Databas…

  pmscorca

  2 replies

  15 years, 3 months ago

  By: pmscorca

• Record Inserted/Updated Timestamp

  Hello I'm new to SQL Server. For a given table, can we identify when was a particular record Inser…

  messages4kanthi

  1 replies

  15 years, 3 months ago

  By: Dan.Humphries

• date format in stored procedure

  create procedure USP_InsertStatusText(@Statustext char(150),@RecievedBy varchar(50),@Deliverydate d…

  kavyacb

  5 replies

  15 years, 3 months ago

  By: Ben Teraberry

• nvarchar(max) truncated

  CREATE PROCEDURE [dbo].[spuGetGlobale] @Anno integer AS BEGIN DECLARE @SQLString nvarchar(…

  stefano.tieri

  4 replies

  15 years, 3 months ago

  By: Ben Teraberry