SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Date and Time weird problem

  Hello, I'll try to explain clearly my issue, I've been creating a managment software for several in…

  vchanliau

  3 replies

  15 years, 9 months ago

  By: vchanliau

• Cannot insert duplicate key row in object' dbo.test' with unique index 'test0'.

  Hi, I have a looping script that inserts data into a table and updates the unique column. I am geti…

  jyoti_bhatt

  10 replies

  15 years, 9 months ago

  By: Dave Ballantyne

• Query

  Hi , I have got a requirement.below are the details. I have 3 tables Event (Id,Name,StartDate), Us…

  Raghunath Garlapati

  6 replies

  15 years, 9 months ago

  By: Kingston Dhasian

• Run query back 24 months from Currentdate

  Hi I have a SQL view that selects data from my tables. What I need to do is to add some code that r…

  j.dibble

  6 replies

  15 years, 9 months ago

  By: Bru Medishetty

• determining what actions a database performs

  Guys I would like to know how do you determine what actions a database performs? For exampe, I wo…

  mstephens1754

  3 replies

  15 years, 9 months ago

  By: Steve Jones - SSC Editor

• Empty Stored Proc takes 8ms to complete?

  Hi, We have a custom DLL written in C++ which calls an empty Stored Proc (through a thread) via the…

  rmudway

  5 replies

  15 years, 9 months ago

  By: Grant Fritchey

• SSRS Tutorials

  Hi Guyz. I am new to this Forum. Can anyone give me a good tutorials regarding SSRS. Thanks in A…

  stalin.d

  4 replies

  15 years, 9 months ago

  By: sql_lock

• Where are the indexes stored

  Hello All, If I am implementing partitions on a very large table, and the table has indexes. Is the…

  SQL-Student

  1 replies

  15 years, 9 months ago

  By: anna.ellis@getronics.com

• SQL Server Clustering

  Hi! My task is to do clustering in SQL Server 2008. So, in order to accomplish windows clustering, …

  Vennila

  1 replies

  15 years, 9 months ago

  By: Gail Shaw

• Error occured when executed a stored procedure from program

  Hi, I was writing a stored procedure for retrieving all the records from ALBUMS table on the basis …

  ABJaisi

  3 replies

  15 years, 9 months ago

  By: ABJaisi

• Looking for SQL Server 2008 Installation/Upgrade Best Practices or FAQ

  We are getting ready to migrate from SQL Server 2005 Enterprise Edition to SQL Server 2008 Enterpri…

  shew

  1 replies

  15 years, 9 months ago

  By: Welsh Corgi

• Speed variance between executing procedure vs excuting t-sql standalone

  Hi I have a strange scenario whereby if I execute a stored procedure it runs for about 2 minutes. …

  all4miller

  2 replies

  15 years, 9 months ago

  By: colin.Leversuch-Roberts

• Transfer logins 2008->2008

  Hi all. Explain me plese how I should transfer logins from one sql server 2008 to another. I tried …

  suvorav

  2 replies

  15 years, 9 months ago

  By: colin.Leversuch-Roberts

• question about sp_spaceused and a full log

  I have a table that has 236Meg 'reserved' as reported by sp_spaceused. The transaction log for the …

  john_s50

  3 replies

  15 years, 9 months ago

  By: ajm34

• Cannot backup local but can backup to network

  Hi, Sorry to start a new thread on this however I did not find an answer in any others so far. I ha…

  Hawkeye_DBA

  5 replies

  15 years, 9 months ago

  By: Jeffrey Williams