SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Stored procedure which has problem with returning values

  Hello, Executing the following stored procedure give me this error: "Msg 201, Level 16, State 4, Pr…

  julien.dutel

  5 replies

  14 years ago

  By: julien.dutel

• How to convert this XML into columns

  How do you convert this XML file into columns, which includes date_changed, rate, changed_by(percen…

  njdevils39

  194 replies

  14 years ago

  By: Sean Lange

• purge data job in suspended state

  Hi Everyone, Hope all is well. I have scheduled a sql agent job to delete data older than 180 days …

  Pyman

  1 replies

  14 years ago

  By: KarenM

• Could I have some deadLock help, please?

  Hello, I am new to working out a deadlock and would really appreciate some help with it and hopeful…

  Duran

  14 replies

  14 years ago

  By: Duran

• How to change NULL into a value when executing a FETCH

  I just wonder how I can solve a problem with a NULL-value being change into another value when I fe…

  TheKasper

  12 replies

  14 years ago

  By: Steve Cullen

• GRANT EXECUTE

  Hi all I ran a grant execute to [Domain\ID] at a database scope to grant the account the ability to…

  Kwisatz78

  3 replies

  14 years ago

  By: Kwisatz78

• SQL server cannot start

  Hi, In one of our server one drive is down which contains the ldf file of tempdb. But other drives …

  Ryan007

  9 replies

  14 years ago

  By: Ant-Green

• Help newbie migration dts 2000 to sql server 2008

  Hello ,i'm newbie here ,i want to ask some help about data transformation system (DTS) .Here is the…

  jeffero_blackk

  1 replies

  14 years ago

  By: Ant-Green

• SSIS packages security

  Please help me how I can implement SSIS package security. It includes storage, deployment and execu…

  rakesh_itcvrce

  1 replies

  14 years ago

  By: Koen Verbeeck

• primary keys

  The vast majority of primary keys I see in all databases are on the id identity fields, I suppose b…

  erics44

  21 replies

  14 years ago

  By: erics44

• sum of group by two columns

  hi i have a data base of 2 tables 1-members(memberid, membername, groupid) 2-bills(billid ,member…

  jcgldr

  2 replies

  14 years ago

  By: Dwain Camps

• varchar(max) field throwing truncated field error

  Hi I run an ASP site which stores its data in sql server 2008. One of its uses is to store blog pos…

  tim 37654

  12 replies

  14 years ago

  By: tim 37654

• Performance effect: Calling SP in the same DB VS Calling SP from other DB

  will there be any performance impact if SP is called from Same DB or Called from Other DB. For exam…

  Joe-420121

  7 replies

  14 years ago

  By: Jeff Moden

• Merge

  Is 'TARGET' and 'SOURCE' reserved keyword in SQL server for merge statement? I was trying MERGE …

  peacesells

  2 replies

  14 years ago

  By: peacesells

• SSIS package configuration organizer throwing errors

  Hi, I'm getting back into SSIS after a long hiatus and I'm struggling with the package configuratio…

  David Korb

  2 replies

  14 years ago

  By: David Korb