KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Questions tagged
sql-server-2000
38 questions
Follow Tag
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