SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• SQL2008R2 to SQL 2005

  Hi, I am a new bie to sql 2008 . I have SQL 2008R2 express edition with advanced services on 1 s…

  Skybvi

  6 replies

  14 years, 10 months ago

  By: Gail Shaw

• How to get object name from server wide DMV ?

  I am doing some performance tuning and currently working with sys.dm_exec_procedure_stats. This is …

  SQL Guy 1

  2 replies

  14 years, 10 months ago

  By: Gail Shaw

• is_published = 1 after SQL 2000 attach in SQL 2008

  Hi I've attached a SQL 2000 database to SQL 2008 (attached from backup files) Compatibility mode …

  007DBA

  2 replies

  14 years, 10 months ago

  By: 007DBA

• Replication

  Good Day we are running SQL Server 2008R Enterprise Edition . We need to replicate some tables to a…

  lianv 90648

  1 replies

  14 years, 10 months ago

  By: Roy Ernest

• Cannot login to SQL Server 2008

  guys, i just did a clean installation of sql server 2008 on windows 7 ultimate, i know the password…

  wordlife74

  5 replies

  14 years, 10 months ago

  By: Adiga

• Set database to Read Only alters order of pk index?

  Sorry for the confusing subject line 😛 In short: I have a database with a table. The table has a PK…

  Dennis-509860

  3 replies

  14 years, 10 months ago

  By: Dennis-509860

• To generate this Output of one column

  CREATE table AD(sno int,sname varchar(20)) insert into ad values(1,'a') insert into ad values(3,'c'…

  nandakrishnacherukuri

  2 replies

  14 years, 10 months ago

  By: nandakrishnacherukuri

• Using a Instead of Recursive Trigger

  Hi, I am having 2 tables namely Table1 and Table 2 Table 1 ID PK Name Desc Table2 ChildID -&g…

  richu.thomas

  3 replies

  14 years, 10 months ago

  By: richu.thomas

• SQL Server 2008 R2: MAX DOP on Windows 2008 R2 impact on data result???

  Hi everybody. I need some help about a 'strange' behaviour I noticed on my test server. The environ…

  lindbergh_ddv

  27 replies

  14 years, 10 months ago

  By: lindbergh_ddv

• sp_spaceused without VIEW DATABASE STATE permission

  Hi, I have tried to search the forums for this, but did not find a match. Apologies in advance if I…

  Christian Buettner-167247

  3 replies

  14 years, 10 months ago

  By: M&M

• Replication subscriber as Read-only DB

  Hi We have transaction replication from Primary to couple read-only servers. These read-only server…

  aMSDeveloper

  2 replies

  14 years, 10 months ago

  By: Red8Rain

• count visit as 1 with the same doctor, id and visitdate

  for example i have table where I have id doctor visit date patient medicine 111 …

  hbanerje

  4 replies

  14 years, 10 months ago

  By: hbanerje

• Database Size

  Hi, Got an application spread across 38 databases, 430 gig used space, 660 gig space reserved on th…

  SteveScanlan

  6 replies

  14 years, 10 months ago

  By: shane-607684

• How to make a fixed default schema for a user?

  Hi, In a SQL Server 2008 instance: 1. Created a login called Scott. 2. Created a user called Scott …

  pshaship

  1 replies

  14 years, 10 months ago

  By: mister.magoo

• Property Text is not available for DefaultConstraint

  Hi, I have granted a user with db_datareader rights and when that user tried to perform SCRIPT TABL…

  pshaship

  1 replies

  14 years, 10 months ago

  By: Johan Bijnens