I have Sql Server 2000 and Word from Office Xp. Since a few weeks, I cannot import Data from my database towards a Word document. I follow the procedure, but at the end, it tells me Word cannot find the data source. If I use Excel, well it works perfectly. What is the gig? thanks ...more >>

I want to copy a database from one server to another. I'm happy about how to do this but also want to copy a number of DTS packages, jobs and alerts that relate to this database. Is there any way that I can copy them or will I need to create them again on the new server. Many Thanks La...more >>

I have a vbscript to read all files from a directory and, if the file is valid, I would like my DTS to process it. I tried using the vbscript as an ActiveX workflow script in the DTS, but it does not execute the data pump until it has completed looping through all the files, so only the last fi...more >>

Hello, I know that this has probably been discussed, but I couldn't find anything with Google. I have the following problem... I receive a set of text files that describe a chain of insurance claims. Each claim may be copied from an older claim and it may be copied to a newer claim. I get fil...more >>

Hi guys I having trouble with this sproc. I get the following error when testing: Server: Msg 245, Level 16, State 1, Procedure UTL_CompletenessCheckLoan, Line 231 Syntax error converting the varchar value 'danwet w125 ' to a column of data type int. I have declared @Sellername as Varcha...more >>

Ok, What format is this to where I can't find records (that I know are there) using this date "2005-09-29 23:58:00". Here is the SELECT that I use that doesn't work: SELECT * FROM RMA_HEADER WHERE CREATED_DATE LIKE '2005-09-29%' Any help is appreciated. Thanks, Trint ...more >>

My multiple level nested corelated query is not fetching correct result. It work fine on small set of data, but fails on larger set of data. Any clue? Explaining data storing and discussing design would be tough for me here, still to show you how complex I have created my life, here is the qu...more >>

In the Portal1 case expression in the script at the bottom I would like to replace where the result 1 is returned, with the substring function returned as Portal {SUBSTRING(Field1, CHARINDEX('tonep', Field1) + 4, (CHARINDEX('.txt', Field1) - 8) - (CHARINDEX('tonep', Field1) + 4))} However, ...more >>

I am using SQL Server 2000. I have some files with SQL-Statements. The SQL-Serveragent runs jobs which execute the SQL-Files: (e.g. osql /E /n /i \\server\d$\lager_pool.sql) How can I implement an error handling. If an error occurs, the script stops, and I can't read the variable @error ...more >>

Hello Everybody: Somebody know how I can create a nested ranking from a analysis services cube, using MDX?.. i mean, sort a sales ranking that show .how % of my clients.....b.buy only 100 articles.......how many clients ....expressed in % , buy just 200 articles parent level using a measure an...more >>

I've started researching on Unit Testing and I must admit I had never heard of Unit Testing until a couple of months ago. Obviously I am interested in Unit Testing Stored Procedures. I read the TSQLUnit documentation (not all of it) and i also ran into a newsgroup post saying TSQLUnit is very...more >>

I have imported some data to sql2k from my old system. Somehow, it imported invoice amount to char type. I just created another column called invamt2 type NUMERIC so I can copy or convert content of invamt which is type CHAR. There are about 50,000 records. How can I convert/cast fro...more >>

Guys, I have a problem with setting up connection from asp file to MS = Sql db.=20 I'm using Web.Config as the file to setup the connection: <connectionStrings> <add name=3D"AMConn" connectionString=3D"Data Source=3DTWS_WS04;Initial = Catalog=3DAccessMed;Integrated Security=3DTrue" provide...more >>

Hello Folks, Last evening, as a result of our autogrow settings, our production database grew from 102 GB to 107 GB. What puzzled me is that, prior to the growth, we still had a good 10% free space left in the data file. My understanding is that SQL Server will automatically grow a database w...more >>

I have a table for storing alerts (exceptional situations) occuring on devices that I monitor. Associated with each alert is an alert code, a description, the device responsible for causing the alert, when the alert was generated, and when the alert was removed (device no longer had the alert) ...more >>

Greetings! Please see my data below, for each account, I would need the lastest balance_date with the corresponding balance. Can anyone help me with the query? Thanks a lot! create table a (account int ,balance_date datetime ,balance money) insert into a values(101,'1/31/2005', 5000...more >>

Hi, I want create stand alone application from DTS package. I remember I did one time ago, I couldnt recall how I did it. Thanks. ...more >>

Following is my table and its content: Year TargetedBudget FirstQuarter SecondQuarter ThirdQuarter ------------- ---------------------- ---------------------- ---------------------- ---------------------- 2000 25000 12000 11000 1000 2001 35000 22000 21000 2000 2002 45000...more >>

Hallo, MSDB.dbo.BackupSet logs all backups is it possible find Status of Backup (Success / Failed)? Table "BackupSet" hasn't any information about it. I need log and notify all backups with status (It must be a windows service (c#) Thanks ...more >>

NEED KNOW IF SOMETHING KNOW CERTANLY .....ABOUT THIS : ********************************************************************************** PLACE A NAMED SET INTO A PIVOT TABLE : ALL ABOUT THIS..FORMULAS...FORMS... EXAMPLES.... ALL ! ANOTHER : GET RELATIONSHIP ABOUT THE FIRST TROUBLE : SEE ...more >>

HI ALL : THIS TROUBLE GET ME TOO BUSY ......PLASE HELP ME !!! I WAN IT KNOW : HOW I COULD ...PLACE A SANED SET INTO A PIVOT TABLE ......AND.....WHAT I MUST MADE FOR : SEE NAMED SET FROM A CUBE ...IN OLAP . PLEASE...A THANK REALLY ALL HELP THAT YOU WANT GIVE ME . I NEED KNOW REALLY ...more >>