SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Data Modelers - Alternatives to Erwin

  I have been asked to find data modeling tools to serve as an alternative to Computer Associate's Er…

  Brandie Tarvin

  40 replies

  6 years, 12 months ago

  By: ajaydeep

• One of my sql database

  Our not large company uses in office SQL Server 2005 during some years. Only couple of days ago we …

  rhinoloon48

  7 replies

  7 years ago

  By: Eirikur Eiriksson

• Database modeling tools

  I have built a database and wanted to verify that it has no obvious errors in the design. previousl…

  ErickTreeTops

  1 replies

  7 years, 1 month ago

  By: halil.lacevic

• I don't know what happened

  I'm not a guru of SQL Server 2005, but some hours ago something has happened. My .mdf denied openin…

  HarounRachedi

  1 replies

  7 years, 1 month ago

  By: VissiaMarino

• Openrowset and Microsoft.Jet.OLEDB.4.0

  Hi, I have seen quite a few requests for help on the subject of importing data from Access and Exce…

  Ronald Cartmale

  16 replies

  7 years, 2 months ago

  By: William Rayer

• A Logical Consistency-Based I/O Error

  Hi all,Here's my problem:I cannot connect tp SQL Server. Getting this error message:Sql Server Dete…

  dgentry 62346

  2 replies

  7 years, 2 months ago

  By: oliver555

• Moving table with Encrypted column to different server

  I have an SQL 2005 Develoment system with one table. The table contains an encrypted column of data…

  DougGifford

  4 replies

  7 years, 4 months ago

  By: Jeff Moden

• view definition from sys.sql_modules -- How does SSMS know how to format it?

  I am building a mini-app that will give some power users the ability to browse tables and views in …

  DavidL

  6 replies

  7 years, 4 months ago

  By: matthew.rhea 29737

• SQL 2005 Full Text Search / Contains Formsof Thesaurus not working

  Hi, I can't seem to use a modified Thesaurus xml file on SQL 2005. I've modified the tsENG.xml, tsG…

  g_demetriou

  2 replies

  7 years, 5 months ago

  By: matthew.james.wilkinson

• High Fragmentation - No Indices

  Just a caveat before I start: Aside from running queries I know very little about SQL server manage…

  notredamon

  5 replies

  7 years, 6 months ago

  By: Jeff Moden

• Error converting data type DBTYPE_DBTIMESTAMP to datetime.

  Hi, I am running an SQL statement that connect ORACLE database to retrieve data. I tried to ru…

  SqlUser-369680

  10 replies

  7 years, 6 months ago

  By: fgordonie

• Alter Procedure vs. Drop/Create

  We have historically administered stored procedures by doing Drop/Create commands instead of A…

  Dave Zahn

  6 replies

  7 years, 6 months ago

  By: Jeff Moden

• There is insufficient system memory to run this query.

  SQL 2005 Ent. Edition - 64 Bit (9.00.4035) Running on Win 2008 R2 - 64 Bit 64 GB of Ram SQL Configu…

  WasimAli

  8 replies

  7 years, 6 months ago

  By: Jeff Moden

• SQLNonTransientConnectionException:A problem occurred when attempting to contact the server (Server returned: Connection reset).

  Hello , I got the below exception in my production logs.My application uses sql login to login to m…

  Pink123

  1 replies

  7 years, 6 months ago

  By: Colleen Rossman

• How to check if a field contains unicode data

  Hi, I want to check if a field contains Unicode characters or not. This is how I have been doing it…

  EITCL

  6 replies

  7 years, 6 months ago

  By: isaac_654135