Stack Overflow
Stack Overflow

Questions tagged [sql-server-2000]

Use this tag for questions specific to the 2000 version of Microsoft's SQL Server. Note that as of April 9, 2013, Microsoft no longer supports this version of SQL Server, to the point that even security patches are no longer created.

SQL Server 2000 (codename Shiloh, version 8.0), released in September 2000, is the successor to SQL Server 7.0.

2591 questions
0
votes
1 answer

SQL Server 2000 SQL Profiler filters ignored

I am not able to filter events in my database. When creating a trace, I specify a "Database Name" in the filters tab and add my database name, "pr200". However, the profiler seems to ignore this information and keeps showing events from all…
AgostinoX
  • 6,923
  • 18
  • 72
  • 120
0
votes
1 answer

Get SQL Server 2000 instance path using C#

I need to relocate files to SQL Server 2000 default data folder programmatically using C#, I have searched a lot but couldn't find a solution. Given below link only works for SQL Server 2005 and above versions. C# How to get SQL Server installation…
Satya Vinod
  • 1
0
votes
1 answer

BCP... queryout execution erroneously returns zero rows where data is know to exist

I have written a BCP process with queryout as option. As a result the query is exectuted and the results are (or should be) written to the designated output file. The query that is being used has been confirmed in SQL Query Analyzer (using MS SQL…
user774512
  • 1
  • 3
0
votes
2 answers

How do I create and synchronize a combined reporting-only db from two live dbs?

I need to quickly implement a read-only database containing data pulled from two identically structured live databases. The live dbs are actually company dbs from a Dynamics accounting system so I'm happy for any Dynamics specific advice but this is…
tetranz
  • 1,832
  • 3
  • 22
  • 30
0
votes
1 answer

Why does this simple SQL query from SQL Server 2000 have different results in SQL Server 2008?

Using MS SQL 2000 it was possible to have a query such as: SELECT (Code + ' = ' + EdiNumber + ',') AS MyResult FROM tblCountry Which would give you a list of results like: MyResult ======== ZW = 263, ZA = 27, ... However, in MS SQL 2008 that…
Jimbo
  • 20,449
  • 37
  • 111
  • 151
0
votes
1 answer

SQL Server 2000 - decode base64 string to image file, or to a file system

Is is possible from a stored procedure in SQL Server 2000 to decode a base64 binary string to an image file? I have to save it to a file system, and that part is solved, I need to get the data in an image file
opensas
  • 52,870
  • 69
  • 227
  • 340
0
votes
2 answers

SQL Server 2000 (creating all dates given a daterange)

I was wondering if there is a way in SQL Server 2000 to create all dates given a start and end date as a result. I know I can achieve this with T-SQL looping. I am looking for a non looping solution. Also in 2005 you can use the recursive with…
user94967
  • 91
  • 1
  • 8
0
votes
1 answer

Generate Script in SQL Server 2000 (in Order)

I want Generate script of all views and functions in my database, but when i execute this script i find a problem of ("object xxx doesn't exist") because i have many views select data from other views, so they should be created before the first…
kamal1899
  • 1
0
votes
1 answer

SQL Server 2000: how to save an Image variable to a file in the file system from a stored procedure

I have a stored procedure that receives a @Data image parameter. And I want to save it to the file system from a stored procedure. Any idea how to do it?
opensas
  • 52,870
  • 69
  • 227
  • 340
0
votes
3 answers

How to insert a string value in the table

Using VB6 and SQL Server How to insert a string value in the table Dim a as string a = 0008", "0009", "1011", "1208 I want to insert this string values in the table Expected Output Table1 ID 0008 0009 1011 1208 How to make a query for the above…
Gopal
  • 10,888
  • 47
  • 141
  • 225
0
votes
2 answers

SQL Server 2000 - Picking one row out of many based on cell value

I've got an interesting dilemma that has stumped me and a coworker. I'm trying to construct a sql query that will allow me to pull phone extensions for an employee to be published on a public website. In our phone system (SQL Server 2000 based) a…
J_D
  • 681
  • 1
  • 7
  • 22
0
votes
3 answers

Can a trigger be forced to run in a separate context than the user in SQL Server 2000?

Let's say I have a SQL Server 2000 table, any name will do, it's irrelevant for this topic. On this table I have a trigger that runs after update or insert. The user is able to insert and update the table on which the trigger is attached, but not…
BenAlabaster
  • 36,299
  • 19
  • 100
  • 147
0
votes
1 answer

TSQL Insert Conundrum

I have a table. The table needs to store a number values about a location, so initially I had just the two columns without the incrementing column, giving the following: RefID | TypeID 1 | 1 1 | 3 1 | 6 2 | 3 3 | 5 3 |…
graham.reeds
  • 15,267
  • 16
  • 66
  • 133
0
votes
1 answer

Limit results to distinct system name when multiple records returned

This is running on SQL Server 2000 Background: when a new server is brought onto the network, it will pass through a series of status (stages) such as (loading, testing, configuring, production, etc) were production is the final step (not every…
HPWD
  • 2,172
  • 4
  • 29
  • 56
0
votes
1 answer

Clean up the "adhoc plan cache" in SQL Server 2005

I found that the "adhoc cache plan" in my SQL Server 2005 occupies more than 1000MB memory. There is a solution on SQL Server 2008 that could solve the adhoc plan by setting the "optimize the adhoc", but it does not exists in SQL Server 2005? Have…
Vance
  • 400
  • 5
  • 15
1 2 3
…
99
100