All Questions
Tagged with sql-server-2005 sql-server-2000
171
questions
0
votes
1
answer
48
views
SQL Server 2000 database after restore to 2005 is empty
I have very old backup file (.bak) of SQL Server 2000. After restoring it to SQL Server 2005, the database looks empty (please see screenshot).
What is the probable cause?
screenshot
0
votes
3
answers
2k
views
Convert Legacy SQL Outer JOIN *=, =* to ANSI
I need to convert a legacy SQL outer Join to ANSI.
The reason for that being, we're upgrading from a legacy DB instance (2000/5 ?) to SQL 2016.
Legacy SQL query :-
SELECT
--My Data to Select--
FROM ...
0
votes
0
answers
559
views
unable to find or download sql server jdbc 2000 driver jar
I tried to add sqlserver 2000 jar file in DBVisualizer tool. I am facing below issue.
This driver requires a JDBC driver class named:
com.microsoft.jdbc.sqlserver.SQLServerDriver.
The problem ...
0
votes
1
answer
120
views
Referencing another table in T-SQL not working
I've been running a query on a large number of servers, and on just three of them (SQL2000, SQL2005 AND SQL2008) the query fails. I've boiled it down to referencing a table in another DB.
SELECT * ...
1
vote
1
answer
84
views
DB restoration issue
I have a issue while trying to restore a DB. Earlier I had SQL Server 2000 on my system so I installed SQL Server 2005 and now I'm trying to upload a DB backup made on SQL Server 2005 only. While ...
0
votes
4
answers
748
views
Copying an SQL table from one Server to another on SQL Server 2000 / 2005
I’m trying to copy a SQL Server table, schema and data, from Server A to Server B. The SQL Server table is just a reference table which hasn't been populated for some reason on Server B. Can anyone ...
0
votes
1
answer
966
views
How to restore sql 2000 database backup in sql 2005?
I am trying to restore backup of a database which was created in SQL 2000 in SQL 2005 and getting this error
Index was outside the bounds of the
array.(Microsoft.SqlServer.Express.Smo)
How can I ...
-1
votes
1
answer
38
views
SQL Server 2000 query conversion [closed]
I have a query written in SQL Server 2000 and I want to re-write that to use in SQL Server 2005 and newer versions.
CREATE TABLE #TEMP(AffinityGroupName VarChar(100), MostPopularVehicle VarChar(100), ...
1
vote
1
answer
1k
views
SQL Job with TRY reports success on failure when inserting from remote SP
I've found a way to fail a SQL Scheduled Job (with severity 16) that does not report failure (and so does not send email notifications). I've fixed my immediate issue, but I want to know why there is ...
0
votes
1
answer
442
views
How to get correct date part from variable sql
There is a need to get the year,month and day part from a date variable.when fired the below query ,it gives day as 8 and month as 4
declare @date1 datetime
set @date1='04/08/2014'
------'dd/...
1
vote
1
answer
35
views
Amalgamating rows in a table and ommitting NULL values
What script would return a table that amalgamates rows by ID in the following table and remove NULL values where an ID appears more than once. So for instance ID 3 appears twice and and ID 217 appears ...
11
votes
3
answers
56k
views
How to convert a varchar column to bit column in SQL SERVER
Flag1 is a varchar column with values "true" and "false". I need to convert this into bit column.
When I try to do this:
Convert(Bit,Flag1)
it shows an error
Msg 245, Level 16, State 1, Line 2
...
0
votes
1
answer
6k
views
RESTORE WITH NORECOVERY sQL
What is the need of "NORECOVERY" option,while restoring the database in SQL SERVER?
One situation in which Server 02 is acting as mirror server in partnership with server 01 ;when mirroring ...
0
votes
2
answers
86
views
SQL Server 2000 - Returning a single column value from a 4 column table based on the values of the other 3 columns
I have a table as follows and I want to run a script to return a single PLAN_ID value for each CARE_ID and these are the conditions. How would I do this? I'm writing the script in SQL Server 2005 but ...
11
votes
9
answers
25k
views
Maximum size of .SQL file or variable for SQL server?
I have a SQL file/SQL string which is about 20MB. SQL server simply cannot accept this file. Is there a limit on the maximum size of the .SQL file or variable which is used to query or insert data ...