SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Unspecified Error on Linked Server after IP Change, related to size of data set returned

  We moved buildings over the weekend, and had to set new IP addresses for some of our servers. Our …

  jvanderberg

  2 replies

  10 years, 9 months ago

  By: jvanderberg

• It seems our sql database is corrupted

  Hi, is there a way to completely check a SQL-Anywhere database (5.5.05) integrity? "Validate" won…

  amrsultan98

  5 replies

  10 years, 9 months ago

  By: liviopagani

• issue with select statement in stored proceudre

  I am trying to alter a procedure..if i edit some record in frontend it will execute this procedure …

  mcfarlandparkway

  6 replies

  10 years, 9 months ago

  By: Sean Lange

• SQL Server 2005 Evaluation download

  Hi guys, Is there any website where I can still download SQL SERVER 2005 Evaluation?? Yes, Yes I k…

  rbednarek

  1 replies

  10 years, 9 months ago

  By: spaghettidba

• sqlcmd: Using double quotes within query(-q)

  How to use double quotes to identify column name within a sqlcmd query using -q Ex: sqlcmd -S srvr …

  sqld-_-ba

  10 replies

  10 years, 9 months ago

  By: casilvis

• Insert Error: Column name or number of supplied values does not match table definition.

  We are migrating from sqlserver 2000 to sql server 2005 and Now i am stcuk with this strange thing …

  KKV143

  17 replies

  10 years, 9 months ago

  By: amarlahon

• How to watch Charleston Southern vs. Georgia: Game guide, TV schedule, streaming

  How to watch Charleston Southern vs. Georgia: Game guide, TV schedule, streaming, odds - 10 Georgia…

  wzbiewom

  1 replies

  10 years, 9 months ago

  By: wzbiewom

• error log on changing the compatibility mode from 80 to 90 in SQL Server 2005

  Can anyone tell us if my changing the compatibility mode of a SQL Server 2005 database from 80 to 9…

  scorpnit

  5 replies

  10 years, 9 months ago

  By: Gail Shaw

• Why are my transactions running in SERIALIZABLE isolation level?

  Hi All We have an in-house application that has frequent deadlocks. When I inspect the deadlock rep…

  Innerise

  5 replies

  10 years, 9 months ago

  By: Gail Shaw

• OLE DB provider "MSDAORA" for linked server "OracleLinkedServer" returned message "Error while trying to retrieve text for error ORA-12154 ".

  Hi When we try to connect oracle database using linked server we face below issues Please help u…

  ahamedsulthan5

  1 replies

  10 years, 10 months ago

  By: Gail Shaw

• Tool to analyze database before changing compatibility level 80 to 90 in SQL Server 2005

  Hello, Is anyone aware of any analyzer/ advisor tool that will help me generate a report of incompa…

  scorpnit

  1 replies

  10 years, 10 months ago

  By: spaghettidba

• OLE DB provider "SQLNCLI" for linked server " " returned message "No transaction is active."

  I have linked a local SQL 2005 Standard Server 32-bit Unclustered to a remote SQL Server 2005 Stand…

  Beratung

  20 replies

  10 years, 10 months ago

  By: karthik babu

• Error: 17207 - Open; Operating System error 5

  Hi. I need your help on solving this error: Error: 17207 FCB::Open: Operating System error 5 (error…

  khahlediet

  6 replies

  10 years, 10 months ago

  By: maheshsqldba7

• Converting TEXT columns to VARCHAR(MAX)

  I have a database designed in SqlServer 7 which uses text columns for the storage of text (size fro…

  Henk Schreij

  7 replies

  10 years, 10 months ago

  By: SQLnbe

• Sa Password Recovery

  Hi All. If i Access to Database with another admin user how to find SA Password What it is >? If…

  ahfb

  4 replies

  10 years, 10 months ago

  By: Gail Shaw