Alex Rivera | Logout

Questions tagged sql-server-2000

38 questions

Sort by: Newest Votes Active
34
votes
1
answers

Restore a SQL Server 2000 backup on SQL Server 2012

sql-server sql-server-2000 sql-server-2012
asked 2013-04-03T13:25:36.947
63
votes
3
answers

How to fix the embedded text qualifier issue while exporting data to CSV flat file?

sql-server ssis sql-server-2000 sql-server-2012
asked 2013-02-11T15:45:16.560
25
votes
2
answers

How can I query the list of database roles in a SQL Server 2000 database?

sql sql-server-2000 sql-server-administration
asked 2013-01-03T16:36:46.780
9
votes
4
answers

Does size of a VARCHAR column matter when used in queries

sql sql-server performance sql-server-2000 query-optimization
asked 2012-12-15T17:36:27.443
17
votes
6
answers

How to select only numeric values

sql sql-server t-sql sql-server-2000
asked 2012-09-30T06:18:12.120
78
votes
6
answers

Is there a way to get a list of all current temporary tables in SQL Server?

sql sql-server sql-server-2000 temp-tables
asked 2011-08-16T08:29:18.957
18
votes
13
answers

How can I generate a temporary table filled with dates in SQL Server 2000?

sql t-sql stored-procedures sql-server-2000
asked 2011-05-25T13:50:01.170
10
votes
2
answers

How to change user's default database using SQL for SQL Server 2000?

sql sql-server sql-server-2000
asked 2011-02-01T01:18:26.210
16
votes
1
answers

Need to convert Text field to Varchar temporarily so that I can pass to a stored procedure

sql sql-server t-sql sql-server-2000
asked 2010-12-05T17:32:32.320
15
votes
4
answers

How do I export a table's data into INSERT statements?

sql sql-server t-sql sql-server-2000 data-export
asked 2010-11-03T01:08:28.183
39
votes
3
answers

What exactly does the T-SQL "LineNo" reserved word do?

sql-server t-sql sql-server-2000 reserved-words
asked 2010-10-29T17:50:20.957
15
votes
5
answers

SQL Server Management Studio: Import quietly ignoring 99.9% of data

sql-server ssms etl sql-server-2000
asked 2010-09-10T19:58:43.217
79
votes
7
answers

Get the time of a datetime using T-SQL

sql-server t-sql datetime sql-server-2000
asked 2010-09-07T07:14:34.183
10
votes
2
answers

Executing stored proc from DotNet takes very long but in SSMS it is immediate

c# .net sql-server ado.net sql-server-2000
asked 2010-07-06T14:31:54.373
22
votes
6
answers

Why does SQL Server 2000 treat SELECT test.* and SELECT t.est.* the same?

t-sql sql-server-2000
asked 2010-06-04T14:11:58.000
14
votes
4
answers

How do I get the list of all stored procedures and their parameters starting with a certain prefix?

sql-server stored-procedures sql-server-2000
asked 2010-02-28T11:38:53.407
964
votes
11
answers

How to Join to first row

sql sql-server t-sql sql-server-2000
asked 2010-01-11T16:44:37.123
17
votes
2
answers

SQL Profiler (SQL Server 2000), how to filter only my activities?

sql-server sql-server-2000 sql-server-profiler
asked 2009-12-18T12:04:28.643
17
votes
6
answers

How can I find unindexed foreign keys in SQL Server

sql sql-server sql-server-2000 foreign-keys
asked 2009-09-10T15:51:32.977
21
votes
4
answers

What Causes "Internal connection fatal errors"

asp.net sql-server iis-6 sql-server-2000 asp.net-3.5
asked 2009-07-20T18:54:47.880
428
votes
21
answers

How do I generate a random number for each row in a T-SQL select?

sql-server t-sql sql-server-2000
asked 2009-06-25T17:17:35.350
10
votes
1
answers

How to figure out which column/value the COALESCE operator successfully selected?

sql sql-server t-sql sql-server-2000 coalesce
asked 2009-05-27T18:50:02.847
17
votes
8
answers

What happened with SQL English query?

sql sql-server sql-server-2000
asked 2009-05-20T06:58:18.133
69
votes
9
answers

ORDER BY DATE showing NULLS first then most recent dates

sql-server sql-server-2000
asked 2009-05-04T20:10:33.110
12
votes
10
answers

How to join two tables together with same number of rows by their order

sql sql-server t-sql join sql-server-2000
asked 2009-04-27T11:52:53.537
11
votes
6
answers

How can I check for average concurrent events in a SQL table based on the date, time and duration of the events?

sql sql-server algorithm sql-server-2000 sql-server-7
asked 2009-04-17T18:44:33.393
19
votes
2
answers

How do I disable errors on string truncation in SQL Server?

sql-server-2000
asked 2009-02-09T15:23:04.380
34
votes
5
answers

t-sql replace on text field

sql-server sql-server-2000
asked 2008-11-14T10:13:48.633
18
votes
5
answers

Regular Expressions in SQL Server servers?

sql-server regex sql-server-2005 sql-server-2008 sql-server-2000
asked 2008-11-06T08:15:03.967
9
votes
5
answers

Is there any way to get a list of open/allocated cursors in SQL server?

sql sql-server sql-server-2000 database-cursor
asked 2008-11-05T16:02:11.840
22
votes
4
answers

Schema, Owner for objects in MS SQL

sql sql-server sql-server-2005 sql-server-2000
asked 2008-10-31T18:29:00.830
1467
votes
27
answers

Check if table exists in SQL Server

sql-server t-sql sql-server-2005 sql-server-2000
asked 2008-10-03T16:00:33.803
18
votes
5
answers

Perform regex (replace) in an SQL query

sql sql-server regex sql-server-2000
asked 2008-09-29T22:16:39.570
160
votes
19
answers

Can I protect against SQL injection by escaping single-quote and surrounding user input with single-quotes?

sql security sql-server-2000 sql-injection sanitization
asked 2008-09-26T12:41:25.720
21
votes
7
answers

How do I perform a case-sensitive search and replace in SQL 2000/2005?

sql sql-server-2005 sql-server-2000 collation
asked 2008-09-22T09:02:10.797
13
votes
4
answers

How do I set the default database in Sql Server from code?

sql-server database sql-server-2000
asked 2008-09-19T21:51:52.033
11
votes
4
answers

Date object last modified

sql-server sql-server-2000
asked 2008-09-16T23:55:18.027
20
votes
8
answers

Have you ever encountered a query that SQL Server could not execute because it referenced too many tables?

sql-server database sql-server-2005 sql-server-2000
asked 2008-08-05T14:54:03.470