Search results for query: *

How do i find out what port it's using?

Hi, i am currently developing a SSRS report using VS.Net 2003 on my local machine. I have insalled SSRS 2000 client tools and i am pointing to a Report Server to deploy my reports (ie https://servername/ReportServer. However, when i try to deploy my report from my local machine to the Report...

Hi, i am new to SSRS so this might seem like a dumb question, but if i have result set that looks like this: LineItemID LineItemDescription LineItemCount 40 Trust Line of Business 2 65 US Government Entity 40 115 Non-US Bank 11 160 Private...

Hi, i need to restore a production backup to a database on a seperate test server. What is the best way to copy the backup (16GB) from the prod server to the Test server? Should i just use ActiveX script to copy the file over or try to create an ftp script? Which is faster?

that will work for a small table, but i have a table with over 10,000 rows. Is there a more efficient way to do it?

Hi, i have the following table: Name ID1 ID2 ID3 ID4 Scott 1111 2222 3333 4444 Jim 5555 Joe 6666 7777 I need to create a new table based on these values to look like this: Name ID Scott 1111 Scott 2222 Scott 3333 Scott 4444...

Hi, i need to populate a datagrid dynamically based on data from a stored procedure that is stored locally using dataadapter. the issue i am having is that the stored procedure uses a parameter and based on the parameter a different set of fields is returned. How do i populate or build the...

Hi, is there a way in SQL server 2000 to see when a login's password last changed?

Hi, i'd like to create a stored procedure in SQL 2000 that runs some insert statements (let's say 3 of them). This stored procedure will actually be called from another stored procedure from another database. What i would like to have happen is if any of the insert statements fail for some...

Hi, i have a very large table (over 200 million rows) that i need to delete duplicate records from. Here a sample of the table: ID CustNum QuestionID Response SystemID --- ------ ---------- -------- -------- 1 100 5 Yes...

Hi, i have a table with 68 columns. I want to do a ltrim(rtrim(column)) for all the columns in the table. Is there a way to automate this somehow? perhaps create some sort of loop to go through each column and to do the ltrim and rtrim? this will be run on a monthly basis through dts package...

Hi, If i have the following 2 tables in a database: Table 1 Cust_ID Contract_ID Facility_ID 10 1 4 10 2 40 10 3 150 10 4 150 10 5 150 Table 2 Cust_ID Facility_ID 10 4 10 40 10 150 How...

Hi, I have an sql 2000 server and need to connect to a db2 database using DTS package. Does anyone have any steps or know any sites with instructions on setting up the DB2 driver and connection? I've connected to other SQL databases before, but never DB2. Thanks scott

does that include the SQLAgentService, SQLDebugger, and SQLServerService? These are all local to the machine...

so you mean drop the local accounts on the local box and then recreate them, then add them on the SQL side?

Hi, I have an SQL 2000 Server running on Windows 2000 Server box. We just renamed the box and i need to add users to the SQL login section with new machine name and when i attempt to i get the folloiwng: Error 15401: Windows NT user or group 'WPWKRIB00002041\swadmin' not found. Check the...

Hi, i received a C# project from a vendor and i loaded it on my machine in MY DOCUMENTS folder and i tried to compile it but got these errors: Error 1 Source file 'C:\Documents and Settings\e909486\My Documents\us.microarts\modules\Logger.cs' could not be opened ('The system cannot find the...

I have a vendor client application installed on a local machine which uses an SQL ODBC connection to connect to SQL Server 2000. I have the ability to run T-SQL commands from within the application. However, when i am executing a certaion stored proc that takes about 2 1/2 minutes to run from...

Can this stored procedure be created in the database that i am backing up or does it have to be created in master?

here is my syntax. I created a backup device call Backup: CREATE PROCEDURE [dbo].[clo_daily_backup] AS begin BACKUP DATABASE ABLTEST to Backup end I am still getting the following: Server: Msg 156, Level 15, State 1, Procedure clo_daily_backup, Line 5 Incorrect syntax near the keyword 'Backup'.