SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Help with Idea on Round Robin TSQL solution

  Hi SQLServerCentral, Here is what I am trying to accomplish and am trying to come up with an approa…

  brad.mason5

  2 replies

  13 years ago

  By: brad.mason5

• Master Database

  Hi, I found that some developers created user created tables in master database recently. Can…

  m.rajesh.uk

  5 replies

  13 years ago

  By: Perry Whittle

• SQL 2008 R2 Backup Question - Log File

  I'm helping a friend troubleshoot an issue with a SQL 2008 R2 database that is sitting behind Share…

  fivetenmm

  4 replies

  13 years ago

  By: Gail Shaw

• Database Virtual Log File count

  Hi, I am using sql server 2008 r2 express.I heard virtual log file count may be the problem for ser…

  IT researcher

  2 replies

  13 years ago

  By: Igor Micev

• Updation using fuction

  Hi I want to perform updation using fuction but I am not able to do it and it throw following error…

  kapil_kk

  10 replies

  13 years ago

  By: kapil_kk

• Linked Server to MS Access

  All, Well, this is kind of three folds... 1. the problem 2. the solution 3. any alternative 1. the …

  sdhanpaul

  2 replies

  13 years ago

  By: sdhanpaul

• Update on ID's

  Hi Guys, Need a more efficient way to do this : Old Fact Table FiscalID SID Value 1 34…

  venkyzrocks

  10 replies

  13 years ago

  By: venkyzrocks

• What causes timestamp/rowversion to update?

  We've got transactional replication setup on a number of tables in a database from one SQL 2008 ser…

  dspeterson

  3 replies

  13 years ago

  By: Sean Lange

• Does microsoft have a tool similar to Red Gate

  One of the guys here in the office thought they had one but has no clue of the name of it. Asked me…

  Sean Grebey

  4 replies

  13 years ago

  By: AlexSQLForums

• Transactional replication

  today we lack of disk space for distribution database primary file and we added space but during no…

  HBK_4700

  1 replies

  13 years ago

  By: Neeraj Dwivedi

• Script Table As -> ALTER To - grayed out??? Why?

  I am using SSMS 2008 and went to add some new columns to a table. I can do this in the design view,…

  Maxer

  2 replies

  13 years ago

  By: brian.battles

• Revoke Grant permission to DB_OWNER

  Hi, How can I 'REVOKE', the 'GRANT' permission to DB_OWNERS members on SQL SERVER 2008 R2 ?

  bruno.perroni

  1 replies

  13 years ago

  By: Lowell

• You will not be able to switch out or switch in data in this table since the table has non storage aligned indexes on it.

  html,body{padding:0;margin:0;font-family:Verdana,Geneva,sans-serif;background:#fff;}html{font-size:…

  SQListic

  1 replies

  13 years ago

  By: Lynn Pettis

• reason for this???

  I've recently run across this structure in a database that I'm migrating. create table fktest ( de…

  Erin Ramsay

  6 replies

  13 years ago

  By: Erin Ramsay

• Questions about extended events

  Hey all, I am trying to learn more about extended events. I have been using SQL Profiler to help me…

  SQLUserC

  10 replies

  13 years ago

  By: Jonathan Kehayias