Search results for query: *

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?

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

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...

Is there a way to use the Backup Database command to backup a database to disk from a stored proc? for example, if you try to run the following command from a stored proc: Backup database ABLTEST to disk='e:\mssql\mssql\backup\Daily\ABLTest.bak' I get the following error: Incorrect syntax...

Hi, i created a DTS package that runs a stored proc and passes the results to an excel spreadsheet. The stored proc takes 1 parameter (BankNum). Because there are numerous BankNum values, I was trying to create an ActiveX script to loop through the dts package and run the stored proc once for...

Hi, i created a DTS package that used a data transformation task to call a stored proc and then writes it out to an excel spreadsheet. However, on the destination tab, i keep getting NewTable in the table name dropdonw, but i really want it to say Sheet$1 instead, since it's going to excel...

Hi, I am trying to create a DTS package that uses a sql stored procedure to generate a set of results and export those results to an excel spreadsheet on a server. The trick is that the stored procedure accepts a parameter for Bank_Number (there are 10 of them). Therefore i was wondering if...