SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Database will not be dropped

  Hi, We have a database without the .mdf and .ldf file (delete by accident). The database is in a su…

  casper.gerk

  6 replies

  14 years, 7 months ago

  By: chandan_jha18

• how to mask the values

  Hi All, I meed to sum the mask values. Ex: 1. sum of 4 and 15 is 15 as 4 is already in 15 2, Sum of…

  rams.prsk

  3 replies

  14 years, 7 months ago

  By: rams.prsk

• DAC-Testing

  I sucessfully enabled the DAC connection in my SQL 2008 While testing the DAC connection through t…

  aby_dvd

  1 replies

  14 years, 7 months ago

  By: aby_dvd

• SQL server 2008 instance rename

  Hi All, Is there any option to change the name of a named instance in sql server 2008. if yes pleas…

  sourav_1002001

  1 replies

  14 years, 7 months ago

  By: Glen J

• Connection went to suspended in sql server 2005

  Hey, I am getting big issue in prod server 2005, when client generate the report connection went to…

  solomon.jernas

  5 replies

  14 years, 7 months ago

  By: solomon.jernas

• Cannot complete sp_changemergearticle......

  I try to set processing_order for merge replication first snapshot. When I run sp_changemergearticl…

  vugarmiriyev

  1 replies

  14 years, 7 months ago

  By: Carlos Rojas

• VARCHAR(MAX) stored off page?

  Hi, lately I've been getting conflicting answers to this. I read somewhere that VARCHAR(MAX) will a…

  Khades

  1 replies

  14 years, 7 months ago

  By: Evil Kraig F

• option of pinning the tables in memory

  Does sql server 2008 r2 support pinning tables to memory. If so do we have any disadvantage? “If yo…

  Pyman

  5 replies

  14 years, 7 months ago

  By: Evil Kraig F

• Odd Timeout Behavior

  SQL Server 2008R2 Standard 64-bit, Service Pack 1. On Win2008 Std Server 64bit Service Pack 1 Sto…

  Chris Becker

  4 replies

  14 years, 7 months ago

  By: Evil Kraig F

• Keeping Audit Log of Order Changes in the database

  Hi, In our Orders application, when a customers makes a change to their Order (Orders are to be del…

  JayK

  3 replies

  14 years, 7 months ago

  By: GSquared

• How to add sys table to diagram ?

  I tried to add a sys table to a SQL Server diagram in SSMS. So far, it looks like impossible. Is th…

  SQL Guy 1

  3 replies

  14 years, 7 months ago

  By: @SQLFRNDZ

• identify applications using sa

  Is there a way that we can identify how many applications are using sa username and password in the…

  Pyman

  11 replies

  14 years, 7 months ago

  By: Lowell

• About XML Explicit

  Hi All, I wanted the resulted xml to look like this : <Root> <QueryWaiting version="B000…

  rams.prsk

  1 replies

  14 years, 7 months ago

  By: RTaylor2208

• Display only Print statement and no result

  Hi All , I have one procedures which makes a call to different proceduers and well it prints some s…

  vineet.bhargava

  2 replies

  14 years, 7 months ago

  By: Jared

• While coding, when do DB requests hit the "too many" or "too much" mark?

  I posted this on a programming forum as well but I'm always interested in hearing the DBA side of t…

  Putts

  11 replies

  14 years, 7 months ago

  By: Steve Thompson-454462