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

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

Hi to all I wish to be able to have a standard select statement which has additional fields added to it at run-time based on supplied parameter(s). ie declare @theTest1 nvarchar(10) set @theTest1='TRUE' declare @theTest2 nvarchar(10) set @theTest2='TRUE' select p_full_name if @the...more >>

Of course I'll try this before I go live, but I figured I'd ask here first. I've read the docs, and the answer is unclear. My current backup strategy is: Take a full database backup occasionally (like, every two weeks). Back up logs every five minutes. This works, but restoring the dat...more >>

Hi. I have lots of processing to do on the server - from the client (Access) I call a sproc which returns a recordset (the sproc is essentially a big "select"). With the obtained data , I need to generate a report. How do I set the Recordsource of the report to the result of the select sproc ? ...more >>

Hi, I just wanted configure this, so the SQL server will be able send messages to my mail address (or any other). Though my mail server exists in a Unix machine, I have configured MS Outlook to pick mails from there, and tested that it sends/recives. My env. is Win XP, with SQL 2000, BUT do...more >>

Even Sa account is in sysadmin role it is not able to create users using enterprise manager Also not able to create users from local admin who is alo on sysadmin role But using query analyzer we can create users Is some thing wrong with master database Sanjit...more >>

I will apologize in advanced for spamming the group with newbie questions. I do not have a reference in front of me and several google attempts have come up on sucessful for the kind of information that I am looking for. That being said here is my question/problem: In a MSSQL database I wa...more >>

Hi everybody Can I replicate a database onto a seperate instance of SQL? I need to replicate a database to a stand-alone machine with no connectivety to anything. Does anyone know where I can find info on this? Thanks for any help. -- Message posted via SQLMonster.com http://www.sqlm...more >>

Ok, In one table, I need to find all instances of multiple entries of an invoice number in the column InvoiceNumber. For example, there may be more than one entrie of 321, 567, and 987 in column InvoiceNumber. 321 skin care product 321 vitamins 321 bottled water 567 rubbing alcohol 56...more >>

Hi all, Hi have a database with a huge transaction log file (plus then 13gb) and I only have 600mb disk space left. I remove the option that allows increasing log automatically, but there are some things that I don't know: 1 - If we could not see the transaction log in an easy way, why he ...more >>

I have a database i am m oving to another server, during the process I am moving the data and log files to another drive.(Which I have done countless times before with no problems) The problem I am having is after I restore the database using the following statement : RESTORE DATABASE CMAMSPROD...more >>

Hi sql server 2005. Is there any way to restore from a backup if the original db has been deleted? I have created a blank db and have tried to restore into it but it says the db is not the same. Thanks Regards ...more >>

Please help me to clean a Windows 2000 Pro instance which is "dirty" with the MSDE 7.0 and/or/both MSDE 8.0 previously incorrect installed/removed. I have a software product installation containing MSDE 7.0. When I tried to install MSDE 7.0 I got an error "You have installed MSDE". *** Sent...more >>

The trick is to use a pivot table Check out the code here http://sqlservercode.blogspot.com/2005/09/fast-date-ranges-without-loops-in-sql.html ...more >>

Hi. Thru a sproc, I drop & re-create some temp tables. When I call that sproc from the client, though, I cannot drop the tables. I need to allow the user, say "Alex", to drop/create tables (actually, that would be DDL). Which role should "Alex" assume ? How do I do that ? I run the followi...more >>

Hi, I have a small theoretical issue. I have one table, which is prettyu large. There is lot of evaluations running on this table, that's why, each process need to wait for another to be finished. Sometimes, for some critical functions, it takes to long time. I don't think that I can speed...more >>

Ok, This script is something I wrote for bringing up a report in reporting services and it is really slow...Is their any problems with it or is their better syntax to speed it up and still provide the same report results?: SELECT t1.MemberId, t1.PeriodID, t8.start_date, t6.amount_type_id,...more >>

We have a console.php which takes in SQL queries and displays them in a result.php webpage. Sometimes the query takes minutes to execute or crashes the PHP application. Is it possible to cancel a query during execution? If yes, how does one go about it. The PHP Console is used by multiple...more >>

Hello All, Could someone please tell me what SQL editor I should use to analyze and update my data on a MS-SQL server. I want to do batch updates of tables in the DB. There is a front end application that only allows me to update one field at a time. While I realize this may be risky I am g...more >>

(Assuming SQL Server 2000, auto create statistics on, auto update statistics on.) Does DBCC DBREINDEX(<tablename>) update statistics? If yes, are the statistics equivalent to those that would be produced by: UPDATE STATISTICS <tablename> WITH FULLSCAN...more >>

Let's say I have two tables: CREATE TABLE dbo.OldTable ( OldID int NOT NULL, OldNote varchar(100) NULL ) ON [PRIMARY] GO AND CREATE TABLE dbo.NewTable ( NewID int NOT NULL IDENTITY (1, 1), OldID int NULL, ComboNote varchar(255) NULL ) ON [PRIMARY] GO ALTER TABLE dbo...more >>

Hi, My table has int Field1 and DateTime dtModificationTime. I maintain a history of changes to the table by inserting a new record with a new dtModificationTime. I need to be able to find the last inserted record. It's easy to do Select * from table where field1=x ORDER BY dtModifica...more >>

Hello I m using a database with MS SQL SERVER 2000, in which I insert SMALLDATETIME values.While using the query browser, with the option "Use local setting for display date, money" unchecked , I get results like : 2005-09-24 00:00:00 With the option checked : 24/sept./05 I get access...more >>

I've created a clustered two column index on a table where the second column is an integer value. When the first column is the same, instead of ordering in numerical order it is ordering 1,10,100,2,20,200 etc. How can I change the behaviour to order the data in numerical order? Thanks, Rick ...more >>

Hi, Periodically I run some very complex queries or stored procedures that "hang", and the bigger problem is that it locks up all of the database clients ie 50 users connecting to the db via a windows application. I never know when this is going to happen, but when it does it leaves all the...more >>

Hi, I've just installed SQL server and then IIS and SQLCE tools. I created a virtual directory and was trying to update the NTFS permissions from SQLServer Connectivity management when i got the following error - Access Control List (structure) invalid. Has anyone come across this and if so...more >>

What are some good strategic approaches to using freeform text fields for data that needs to be queried? We have a product whose tables we can't change, and I need to count on a "description" field for storing a value. Two, actually. I'm thinking of adopting this convention: InvoiceNumber@Ven...more >>

Hi, I'm using isql to query data and output the same to a flat file. The isql has the following command options ' -h-1 -w500 -n -b -s"" '. In the SQL_CODE, the first two lines before the select statement are use dbname set nocount on go When I run this, an additional blank line i...more >>

At my job is a dts package that is failing in SQL 2005. I am not a SQL expert. I am just trying to fix. I put the query in Query Analyzer and get this error: (4322 row(s) affected) Server: Msg 535, Level 16, State 1, Line 1 Difference of two datetime columns caused overflow at runtime....more >>