SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• 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, 10 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, 10 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, 10 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, 10 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, 10 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, 10 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, 10 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, 10 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, 10 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, 10 months ago

  By: jeevan.jeev1

• How to get Database in mix mode?

  Hi, I have installed SQL Server 2005 on my pc but it's in windows authentication now i want it to B…

  g.vijaykumar50

  1 replies

  14 years, 10 months ago

  By: Latheesh NK

• how to move the records to another table that exceeds 10 days

  Hi, I want to move the records to another table if that record exceed 10 days

  kuppurajm

  3 replies

  14 years, 10 months ago

  By: Latheesh NK

• enable intellisence while open 2005 db in 2008

  Hi, sqlserver 2005 installed in server.while I am opening the db from that server through my l…

  kuppurajm

  2 replies

  14 years, 10 months ago

  By: kuppurajm

• Change scripting template in SSMS

  Hi, I'd like to use "IF EXIST" option to script objects on Management Studio. But the way it's impl…

  Sergiy

  1 replies

  14 years, 10 months ago

  By: Sergiy

• On job agent but not on desktop: SSIS Oracle 11g OLEDB unicode error

  Let me begin by reiterating that this error occurs when run on an SSIS server but not when run on t…

  oscar.leeper

  4 replies

  14 years, 10 months ago

  By: peter.a.dawson