Tagged Questions
0
votes
1answer
28 views
SQL Server 2000 trace file extension
Are SQL Server 2000 trace files generated in a .tdf format, the same way as SQL Server 2008 R2?
Thanks
3
votes
2answers
75 views
SQL server 2000 transactions with the same time
I have a BIG problem here.
I'm creating a program that can be looping if the connection to the server is broken.
But when the program is running for a few months, I found a bug on SQL server 2000.
I ...
1
vote
1answer
94 views
How to delete and create user remotely on SQL Server 2000
My boss wants to make sure that no one runs a job accidentally so we are setting up lots of safeguards to ensure that no one sleepwalks, log into the system and run a job. We are updating the ...
0
votes
0answers
29 views
Shrinking SQL Server 2000 database [duplicate]
Possible Duplicate:
Shrinking SQL Server 2000 database
I have become the defacto SQL Server Admin and I have been tasked with moving a production database to a new server. I am trying to ...
2
votes
2answers
122 views
Shrinking SQL Server 2000 database
I apologize for the long question. I am trying to learn a lot on the fly as I have become the defacto SQL Admin. I have been tasked with moving a production database to a new server. My goal is to ...
3
votes
1answer
172 views
SQL Server 2008 upgrade advisor tool
We upgraded to SQL Server 2008 from SQL Server 2000. But due to some legacy scripts/queries in our health care application, that run only in 2000, we had to run 2008 version on backwards compatibility ...
2
votes
2answers
58 views
What tasks can only sysadmin's do in SQL Server 2000?
I'm cleaning up permissions on my SQL Server 2000, and I want to test that a particular account still has sysadmin priveldges. What non-destructive tasks can only sysadmins do that I can use to ...
1
vote
1answer
469 views
How to truncate all tables with a specific name in all databases
I want to delete all tables named error_log in all of my databases that have such a table.
truncate table error_log
I am using SQL Server 2000.
2
votes
0answers
89 views
How unsafe is it to change the data source of repl_distributor on a publisher
I have a long story that I will condense to a few bullet points that leads up to my question
Reporting Server (SQL 2008) is distributor/subscriber cluster for a SQL 2000 Transactional Publication
...
4
votes
2answers
460 views
Log Reader replication agents are constantly restarting
I am recreating (push) transactional replication from a SQL 2000 instance to a SQL 2008 instance which I had to break in order to do a db migration. The 2008 instance is both the distributor and a ...
3
votes
1answer
481 views
Script to Restore/Create SQL Server 2000 Database from Another Database's Backup
I'm trying to create a database, NewClientDB, by restoring another database's, OldClientDB, backup, d:...oldclientdb.bak. I've always done this via SQL 2000 Enterprise Manager, but the GUI keeps ...
5
votes
2answers
119 views
querying a table of events for reporting
The background (masking a real-world problem behind a word problem)
Farmer Brown has a peach orchard in California and ships hundreds of
thousands of peaches all across the country. When a shipment ...
1
vote
3answers
105 views
What is this error about in sql server?
Trying to restore database, getting a dialog in SQL Server Management Studio
You cannot select
backup sets from different databases"
Any idea why I am getting this error?
BTW backup is from ...
1
vote
2answers
367 views
How to add ansi null and ansi warning in connection string
Using RDO Connection
Connection String
Set RdoVisPay = rdoVISENV.OpenConnection("VISA", 1, False, "DSN=VISA;UID=sa;PWD=sa;APP=Visual Basic;WSID=" & ServerName & ";DATABASE=" & ...
0
votes
1answer
344 views
Who changed the job schedule on a SQL Server Agent Job (SQL 2000)
Someone (or some unknown process) changed the job schedule on
a SQL Server Agent Job on a SQL 2000 database. The original
start time was 6:00, but was changed to 4:45; that much I can determine.
Is ...
1
vote
1answer
704 views
Heterogeneous queries error using stored procedure
Stored procedure
ALTER PROCEDURE Proc_DayShift
AS
insert into #Punching_History SELECT * FROM SERVER2.MARS.DBO.TABLE1
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO
SET ANSI_WARNINGS OFF
...
3
votes
2answers
501 views
Query execution showing error as login failed
I want to retrive the table values from other server
Query
EXEC sp_addlinkedserver @server = 'OPSERVER', @srvproduct = 'SQL Server'
EXEC sp_addlinkedsrvlogin @rmtsrvname = 'OPSERVER', @rmtuser = ...
2
votes
2answers
103 views
strange behavior with Turkish language setting
I have database with Collation Arabic_CI_AS
when I have windows with English settings I can do
select Column from Table where Column= 'A'
and can do
select column from table where column= 'A'
...
1
vote
1answer
65 views
SQL Server 2000 query error
When I attempt to run on the SQL Server 2000 to a query which was developed for SQL Server 2008,I receive the following the error.
ambiguous column name SucNo
Here is my query:
SELECT ...
2
votes
1answer
458 views
Table Variables - Scope Error - Must declare the variable 'X'
This is my first post and not sure how to fix this auto format draft?
Using SQL Server 2000.
The table variable that is giving me this one error is '@SBLH'
The following is the multi-select function ...
0
votes
1answer
104 views
sql 2000 trace : sp_releaseschemalock
For a SQL 2000 server, is it bad to see too many
exec sp_releaseschemalock 1
events in a SQL trace file?
0
votes
3answers
919 views
Figuring out database timezone
Does anybody know of a way to alter a time zone on a SQL database? Is there any tool that could find the objects using the date and time?
3
votes
4answers
747 views
tempdb in sql server
Using SQL Server 2000, I am getting the following error.
The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space."
How to solve it? I ...
2
votes
1answer
337 views
Changing SQL Server 2000 usernames
We're running a SQL Server 2000 instance with users tied to Windows accounts. Many of the usernames have spaces in them and that is causing us some problems now. We would like to be able to rename ...
1
vote
0answers
513 views
DBCC CheckDB Consistency error on an empty table [duplicate]
I restored a DB from SQL Server 2000.
I ran DBCC CHECKDB on SQL Server 2000, and it did not report any errors.
What could be the reason behind a DBCC CHECKDB reporting a consistency error on a empty ...
6
votes
1answer
2k views
SQL Server 2000 : List and Disable all triggers
I have to do a database cleanup for one of our databases on a sql server 2000 environment. The cleanup basically includes the disabling of all triggers, deletion of all old data, enabling of the ...
