SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Grant permission to only few tables in DB 2008

  Hi, I need to give SELECT permission to only few tables and one view in a database to a SQL user. A…

  SqlSavvy

  1 replies

  14 years, 12 months ago

  By: SQLRNNR

• Moving a 2005 database that has legacy SQL2000 schemas to SQL 2008 R2.

  Hello everyone, I think I know what I am going to do, but I'd be crazy not to run it past you guys …

  Duran

  3 replies

  14 years, 12 months ago

  By: Welsh Corgi

• Failed to load msxmlsql.dll

  I am getting this error when i am trying to run DTA(db tuning advisor).Pls help me in fe=iguring ou…

  Manvendra

  1 replies

  14 years, 12 months ago

  By: Sean Lange

• Upgrade advisor

  I know this is early, but wondering if Microsoft has a tool to show you the deprecated features for…

  Sailor

  1 replies

  14 years, 12 months ago

  By: Sean Lange

• SqlServer 2008 installation error

  Hi all, I have installed Sql Server 2008 on my windows XP. now unistall it and I try to reinstall S…

  orkun çapraz

  3 replies

  14 years, 12 months ago

  By: FTdenali

• Fake SQL Server Statistics

  I thought I would ask a general question since I have not found an answer yet. We have quite a few…

  pwo311

  9 replies

  14 years, 12 months ago

  By: Ninja's_RGR'us

• add table to a linked server

  Hi I have a linked server (linked to an oracle schema) and i want to add a table that exists in the…

  erics44

  4 replies

  14 years, 12 months ago

  By: erics44

• Create Stored Procedure

  Hello All I have a database named 'MyDatabase' in Sqlserver 2008R2. In 'MyDatabase' i have one tabl…

  Eskandari

  10 replies

  14 years, 12 months ago

  By: jcrawf02

• Full text search works ONLY for English Word Breaker Setting for few words

  Hi, I need to perform full text search for this keyword "CN-OPS-R0196.CN-OMP". I am trying to sear…

  phanisls

  1 replies

  14 years, 12 months ago

  By: phanisls

• Migration From MSSQL 2008 to MSSQL 2008R2

  Test Environment: I have MSSQL 08 and MSSQL 08R2 servers ,in our test Environment ,running at two d…

  azhar.iqbal499

  12 replies

  14 years, 12 months ago

  By: azhar.iqbal499

• Moving Secondary file in user database.

  Hi Folks, I've a test database which is having the .mdf and .ldf files in D:\Testdatabase\ and now …

  MasterDB

  8 replies

  14 years, 12 months ago

  By: ModestyBlaise84

• Central Management Server (CMS)

  Hi all, Anyone know if CMS can run scheduled SQL jobs against multiple servers? Thanks

  neillewis

  3 replies

  14 years, 12 months ago

  By: neillewis

• Getting an Error

  Msg 8152, Level 16, State 14, Line 1 String or binary data would be truncated. I just created a dat…

  dlmagers

  6 replies

  14 years, 12 months ago

  By: dlmagers

• SQL Server 2008 R2 Linkserver to Oracle 10g(or 11)

  I have two servers who behave quite differently accessing the same Oracle 10G instances. Server 1 i…

  jnsnfl

  2 replies

  14 years, 12 months ago

  By: Syed Jahanzaib Bin hassan

• update a column in sql using ssis derived column datatype conversino error

  Hi, I have a table with three columns with the following names and data types of the columns colum…

  jeevan.jeev1

  2 replies

  14 years, 12 months ago

  By: jeevan.jeev1