How do I indicate a post answered my question?
While reading a reply to your question you will notice a button with this Icon: Clicking on it will mark the post as the answer to your question
Thanks!
Clifford Dibble
Hi MMWOPS ..
Extremely thanks for the reply . I am using transactional replication for the database . I will try with snapshot replication as you suggested .
You mentioned that it will work with Transactional replication only if the application uses the option ' with log ' for those transactions .
Can you let me know where can i set this option for transaction replication ?
I am sorry but i am not well versed with database replication procedures and management .
Thank you once again .
Yatin.
Hello all,
So Im looking to deploy my project and click once deployment will not be suitable. So in creating a setup project I need to create some custom actions and also some launch conditions.
Problem being is I need to get the GUID of the application I will be installing for the launch condition.
I read here http://msdn2.microsoft.com/en-us/library/f09xywha(VS.80).aspx
there is a tool to allow you to see the GUID of an already installed application on the developers machine.
It says -
The Component ID is a GUID assigned by a package during installation; it does not match any of the deployment project properties. To determine the Component ID, you must install the application and use a tool such as the MSI Spy tool included in the Windows Installer Software Development Kit.
My question is where can I find this tool?
I already have installed vs 2005 team developer edition, .net 3.0 sdk, .net 2.0 sdk, debugging tools for windows, etc...
But I cannot find searching google, or on my computer a tool to do this for me. If anyone can offer some assistance that would be great.
Thanks
Edit -
No longer needed, just had to dig through regedit a little bit.
Hello friends , I have table (MoneyTrans) with following structure
[Id] [bigint] NOT NULL,
[TransDate] [smalldatetime] NOT NULL,
[TransName] [varchar](30) NOT NULL, -- CAN have values 'Deposit' / 'WithDraw'
[Amount] [money] NOT NULL
I need to write a query to generate following output <br>
Trans Date, total deposits, total withdrawls, closing balance <br>
i.e. Trans Date, sum(amount) for TransName='Deposit' and Date=TransDate , sum(amount) for TransName=Withdraw and Date=TransDate , Closing balance (Sum of deposit - sum of withdraw for date < = TransDate )
I am working on this for past two days with out getting a right solution. Any help is appreciated
Sara
Hi all,
I'm having a problem working the SQL out for the following:
I have a table Person:
personId----------name
1----------------Robert
2----------------Frank
and another table Question
personId------questionId---------answer
1-------------1-----------------Y
1-------------2-----------------Y
1-------------3-----------------Y
2-------------1-----------------Y
2-------------2-----------------Y
2-------------3-----------------N
and I am trying to find a way of returning a list of ids of people who have answered Y to the first and second questions but N to the third.
If I try:
SELECT DISTINCT personId FROM Person INNER JOIN
Question ON question.personId = Person.personId
WHERE (Question.questionId = '1') AND (Question.answer = 'Y') AND (Question.questionId = '2') AND (Question.answer = 'Y') AND (Question.questionId = '3') AND (Question.answer = 'N')
I get no records returned.
I've tried putting brackets around the :
((Question.questionId = '1') AND (Question.answer = 'Y'))
bits of the Where clause - but the query analyser takes them away.
Any help would be greatly appreciated!
Hi All:
I have a SSIS which have a main connection to a SQL Server 2005 DB, and also another connection to a Oracle database, and fetch data from the Oracle db.
I have the 2 connection managers, and everything runs fine when I test it in dev studio.
However, once I imported it to the DB, and run it on command line, I get the "Class not registered" error.
Log file as follows:
C:>dtexec /DTS "MSDB ST1INST101CRDA_D_GIM_CONN_TEST" /SERVER crpnycmsq34q /CONNECTION "CRD_CM";""Data Source=crpnycmsq34qST1INST101;Initial Catalog=CRD;Provider=SQLNCLI.1;Integrated Security=SSPI;"" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING V
Microsoft (R) SQL Server Execute Package Utility
Version 9.00.3042.00 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 1:23:53 PM
Info: 2008-02-28 13:23:53.91
Code: 0x40016040
Source: CRDA_D_GIM_CONN_TEST
Description: The package is attempting to configure from SQL Server using the configuration string ""CRD_CM";"[dbo].[CMG_SSIS_CONFIG]";"GIM_SOURCE";".
End Info
Info: 2008-02-28 13:23:54.03
Code: 0x40016040
Source: CRDA_D_GIM_CONN_TEST
Description: The package is attempting to configure from SQL Server using the configuration string ""CRD_CM";"[dbo].[CMG_SSIS_CONFIG]";"GIM_USER";".
End Info
Info: 2008-02-28 13:23:54.05
Code: 0x40016040
Source: CRDA_D_GIM_CONN_TEST
Description: The package is attempting to configure from SQL Server using the configuration string ""CRD_CM";"[dbo].[CMG_SSIS_CONFIG]";"GIM_PWD";".
End Info
Error: 2008-02-28 13:23:54.55
Code: 0xC0202009
Source: CRDA_D_GIM_CONN_TEST Connection manager "GIM"
Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040154.
An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".
End Error
Error: 2008-02-28 13:23:54.56
Code: 0xC00291EC
Source: Execute SQL Task Execute SQL Task
Description: Failed to acquire connection "GIM". Connection may not be configured correctly or you may not have the right permissions on this connection.
End Error
Warning: 2008-02-28 13:23:54.58
Code: 0x80019002
Source: CRDA_D_GIM_CONN_TEST
Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
End Warning
DTExec: The package execution returned DTSER_FAILURE (1).
Started: 1:23:53 PM
Finished: 1:23:54 PM
Elapsed: 1.547 seconds
I DID TRIED MY BEST to search before posting, and most of them are having problem with 32 bit and 64 bit executions.
However, in my case, both are 32 bit (as shown in the log file).
In the above test, I'm setting DoNotSaveSensitiveData, and then fetch it with package configuration.
To make sure the package configuration is not creating pblm for me, I also tried to hardcode everything in the package, and then encrypt the whole ssis with password, and run the package with the /DECRYPT option, so that everything is already intact.
But I still get the same error. Log file as follows.
C:>dtexec /DTS "MSDB ST1INST101CRDA_D_GIM_CONN_TEST" /SERVER crpnycmsq34q /De "painful" /CONNECTION "CRD_CM";""Data Source=crpnycmsq34qST1INST101;Initial Catalog=CRD;Provider=SQLNCLI.1;Integrated Security=SSPI;"" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING V
Microsoft (R) SQL Server Execute Package Utility
Version 9.00.3042.00 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 2:24:25 PM
Error: 2008-02-28 14:24:27.11
Code: 0xC0202009
Source: CRDA_D_GIM_CONN_TEST Connection manager "GIM"
Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040154.
An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".
End Error
Error: 2008-02-28 14:24:27.14
Code: 0xC00291EC
Source: Execute SQL Task Execute SQL Task
Description: Failed to acquire connection "GIM". Connection may not be configured correctly or you may not have the right permissions on this connection.
End Error
Warning: 2008-02-28 14:24:27.14
Code: 0x80019002
Source: CRDA_D_GIM_CONN_TEST
Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
End Warning
DTExec: The package execution returned DTSER_FAILURE (1).
Started: 2:24:25 PM
Finished: 2:24:27 PM
Elapsed: 1.422 seconds
Can anyone suggest what is missing ?? or what can be done ??
Any pointers are greatly appreciated.
Thanks,
- Henry.
Hi,
How to i get reminder of a number?Is there a function like MOD?
Hi there,I need help with setting up a reminder in my sql.It needs to check the inventory on hand for a product and if it isbelow 3 unit, it needs to send an e-mail reminder to the user.how do I set this up?Thanks,
View 1 Replies View RelatedHello !
I'm currently working on a big report project.
There is a main report and about 15 subreports in that main report
There is nothing more than subreports in the main.
Since sub-reports are very similar from one to another, i'm trying to find a way to remind at every page the name of the subreport which is currently displayed.
I've tried two solutions... doesn't work :
A textbox on the main report... but only the name of the main report is available
A textbox on every subreport... but then, the name of the subreport appears only at the end of the subreport, which comes oftently after more than 10 pages.If someone should help for that, i would be grateful.
Rod
PS : don't hesitate to ask details, my english might not be perfect
I don't know much about broker service so I have question. We have a content management system the we developed locally, and what we have are catagories and subcatagries. When people choose a topic we send them an email about the topic they are interested in. We are now selling webinars and white papers and articles on demand. We would like to be able to send a reminder email to anyone who signed up for a webinar or special event. Is this possible with broker service?
View 4 Replies View RelatedHi guys,I hope somebody can help as I am trying to write a procedure in SQL that will be an email reminder sent to users on every 5 th or the month if they don't submit data before.
I am quite new to sql and procedures in particular so I was hoping somebody can help.
I need to:
1.Check the day of the month, if not 5th do nothing
2.Get the date of the prevoious month (get current date - 1 month,set day to 1)this is the funny bit.
I have a field DateEntered,but users only select the month and the year on the acctual page,but when submitted it gets written as a full date and defaults to the 1st of the month.
3.Get the list of hospitals that haven't got data for the previous month
4.Email the hospitals.
DECLARE @returnDay int;
DECLARE @DateEntered datetime;
SELECT @returnDay = DatePart(day,GetDate())
If @returnDay = 5 (syntax error near 5)
BEGIN
SELECT @DateEntered = GetDate() - 30
Print DatePart(month, @DateEntered)
I was hoping somebody could look at this and help me.
thanks
Hi Experts,
I have a table with fields:
remindWHO remindWHEN remindWHATsomeone@test.com 6/20/05 do blah blah
I want SQL Server Agent automatically run every morning at 1:00 AM, check against "remindWHEN" date, if match with current date, send out email to "remindWHO" for what they need to do in "remindWHAT"
I was told this can be done by using the "Jobs" feature under SQL Server Agent to do this, but I don't know how to write Transact-SQL-Script under "Job Step".
Please help me. Or any better alternative?I appreciate for any help.
We have a difficult requirement.
When records are initially created, they are given statuses of New, Pending, Closed
By default, the status is New.
If no action has been taken after 15 days since the records were created, users are sent a reminder.
I have this part working.
The problem is that as long as the status is not equal to closed, start sending reminders every 10 days.
Here is what I am working with:
SELECT [ID] , [Name], [Email],
Status
FROMmyTable
WHERE Status_Name != 'Closed' AND Status_Name IS NOT NULL and Status_Name = 'New' and Status='Pending'
AND CONVERT(Char,DateAdd(day,-15,getdate()),101) = CONVERT(Char,Date_Entered,101)
I am tring to send an email reminder to multiple users using a cursor.
declare emailCursor cursor for
select name,info,default_email, @MyMessage
from My_Temp
open emailCursor
fetch next from emailCursor into @Name,@info, @Recipients,@MyMessage
while(@@FETCH_STATUS = 0)
begin
-- select name,info,ins_default_email,@MyMessage
--from temp
EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'Hello',
@recipients = @Recipients,
@from_address = '<address.com>',
@Body = @MyMessage,
@subject = 'Subject'
fetch next from emailCursor into @Name,@info, @Recipients,@MyMessage
end
close emailCursor
deallocate emailCursor
Currently I have two users in my table that I want to send email to, but when the stored procedure runs I got two emails for the last user in the table instead one for each user.
in sql server 2000 ,in query analyzer :for example i have a emp table ,when i execute a query ,i have to get the emp table column names with its data types...for example :empno ---intempname -- varchar like this...what is the query to get the output like this
View 3 Replies View RelatedHow am I able to read replies to any message? I used to be able to see the replies staggered under the original message...but not any more.
Help!
Toni
Yes, I need to join the two tables with a similar column and then restrict with the where function, correct?
Thanks!
Scott
I am not using the SA account when I log in using windows authentication it seems to pick up my domain and active directory ID which is "usapp1dxd" it appears greyed out as well as the password on the login screen so you can't change it.
If you go into the management studio and right click on the server name in the left hand pane go to properties security the radio button for sql server and Windows authentication mode is selected.
For the begining thank for your reply. I started with a new job and I was hopeless when all normaly claimed things can't be done. I asked a lot of peoples who works on MSSQL(including SWYNK) for my problems(I know that I'm beginer on MSSQL) but they didn't knows any solution. And afterall I wrote that. For your ilustration, we develope information system for Invest company. Back is on MSSQL and client is in ASP.
>So... if you need a database you need to look at what needs to be done and >pick your DBMS that meets your requirements.
--I didn't resolve on which DB we will develope:((
--No named cursors
I mean that in general is using curosr names bootless. And you must deal with names...
In interbase:
DECLARE var1,2 INTEGER;
FOR SELECT column,column2 FROM TABLE WHERE ...
INTO :var1,:var2
BEGIN
some code in loop;
END
In mssql:
DECLARE ..
DECLARE crs CURSOR
FOR SELECT ...
OPEN crs
FETCH NEXT FROM crs INTO @var1,@var2
WHILE (@@FETCH_RESULT = 0)
BEGIN
some code in loop
FETCH NEXT FROM crs INTO @var1,@var2
END
CLOSE crs
DEALLOCATE crs
-I thing that in mssql it isn't elegant.
-problem with recursive procs
-you must deal with names
-If you can you may use named cursors in Interbase in fact
>-it don't know create resultset's from
>> stored procs asynchronously when in sp is something else then only one
>> select(problem if I want check access rigths to sp. for exapmle "...AS
>> CheckPrivilege( ... ) SELECT.." This is confusing if user runs large
>> query & he must wait until it creates the whole recordset...Armageddon goes
>> first... Here is a solution, but it isn't very elegant and in some
>> cases don't exists good solution
>
>I'm not sure if configuring SQL Server's "cursor threshold" parameter would solve this. "When
>set to -1, all keysets are generated synchronously. If the cursor threshold is set to 0, all
>keysets will be generated asynchronously."
-"cursor threshold" resolves it only in single select's and procedures with only one select's
-It's unacceptable when your your user runs large queries
>>-max of nested procs is 16.
>That is the limit in V6.5. In V7.0 the limit is raised to 32.
-cool:)
>Union operator can't be used in a Create View statement in V6.5 according to the documentation.
>Does Oracle support this? It appears that V7.0 of MSSQL will support UNION in a view.
-cool:))
>-It don't have good exception
> handling.(something like EXCEPTION, WHEN... (oracle, Intebase))
>
>There are whole sections on error handling in SQL Books OnLine depending on >how you are
>accessing SQL Server. Maybe it's as good as Oracle/Interbase... maybe not. I >don't seem to have a problem with it.
-Books are very feeble:(
-but I thing that it can't work with EXCEPTION blocs. Good Exception handling is important tool for fast developing of robust apps
-I used example(s) from INTERBASE because I worked more on it, but in Oracle it's alike.
I'm glad for good discussion
Beargie
For a query like below ...
How do i have to select only the latest revisions,
if i need to filter last current revisions of each document ...
where the revision could be either alphabetical or even numerical ...
Presently I get all revisions with the below query ...
Note: csd_revi is the field of CSD table for revisions.
---
select distinct
csd1.csd_orig + csd1.csd_subj + csd1.csd_type + csd1.csd_numb + csd1.csd_revi as "Document Reference No.",
csd1.csd_labl + ' ' as "Description"
from
E0437csd csd1,
E0437tra tra1,
E0437csd csd2,
E0437trd trd1,
E0437apr apr1,
E0437apc apc1,
E0437tra tra2,
E0437csd csd3,
E0437trd trd2
where
csd1.csd_orig = 'BS' and
csd1.csd_subj like '%WN1%' and
csd1.csd_type = 'D' and
tra1.tra_drgn = csd1.csd_orig + csd1.csd_subj + csd1.csd_type + csd1.csd_numb + csd1.csd_revi and
tra1.tra_part = 'PARSO' and
tra1.tra_type = 'A' and
csd2.csd_orig + csd2.csd_subj + csd2.csd_type + csd2.csd_numb + csd2.csd_revi = tra1.tra_trno and
trd1.trd_trno = tra1.tra_trno and
trd1.trd_cc = '0' and
trd1.trd_part = 'PARSO' and
apr1.apr_docu = csd1.csd_orig + csd1.csd_subj + csd1.csd_type + csd1.csd_numb + csd1.csd_revi and
(apr1.apr_stat = apc1.apc_code or apr1.apr_stat = '') and
tra2.tra_drgn = csd1.csd_orig + csd1.csd_subj + csd1.csd_type + csd1.csd_numb + csd1.csd_revi and
tra2.tra_part = csd1.csd_ownr and
csd3.csd_orig + csd3.csd_subj + csd3.csd_type + csd3.csd_numb + csd3.csd_revi = tra2.tra_trno and
trd2.trd_trno = tra2.tra_trno
order by
csd1.csd_orig + csd1.csd_subj + csd1.csd_type + csd1.csd_numb + csd1.csd_revi
---
Life is beautiful ... When you smile ...
I've gotten everything to work -- almost!
Here's the scoop... I'm using SQL Server 7.0 and ColdFusion (you don't need to know anything about ColdFusion). I'm trying to get SQL Server to publish/share/etc. a database with the network so ColdFusion (our website management/creation program) can access it and use it in a webpage. Well, so far, ColdFusion can detect and access the database (called "iami"), but it cannot find any tables in the database (particularily one called "phase1"). Can anyone help me -- the sooner the better -- ???
If you reply before 4pm today and offer truly helpful advice/input, I'll send you a reward/incentive from me personally (just give me your mailing address) just for helping out!!! :-)
I can believe it, 40 people read my sql query problem and ONLY ONE reply to my request for help.
Thanks!!!! It's great to know that we help each other in this community.
Can anyone help me with handy scripts/stored procedures to capture blocking info on the server? We have SQL 7.0 w/sp3.
Ray replied earlier saying that I can use so_who2!!, I think everyone knows that,please reply with some valuable info!!Please..
Thanks.
Sonali.
I think jthis is a bug. I have a table created and populated on its own filegroup. I backup the db(all filegroups) and the trans log then I drop the one table. When I try to restore from my backups, it insists that I back up the trans log again. I do, then do the restore of both the filegroup and the trans log. The restore finishes, but my table is still not there and I can never get it back.
Any one with comments please help
Brad kreuzburg
What should I have done? Is there anything that can be done other than restoring from backup?
How does one know if the database is really recovering or is EM just joken? I can wait 2 hours
before starting the restore
I was BCPing 12 million rows into a staging table. II used the '-b' option every 20K which I thought
would do a commit and clear the log in batches. After the process EM appeared to show the transaction log
as empty. Upon inspecting the Bcp output file I discovered the message that the BCP did not complete
because syslogs was full. I could not do a truncate transaction log or a dump database. I tried to
do a truncate transaction with no_log and it appeared to just hang. I stopped the SQL Server thinking
I could dump the transaction log, but could not start the Sql Server again. I then stopped the NT Server
because 'if all else fails'. The SQL Server started but the user database if marked as recovering.
I cannot reply to any messages of the board? Is anyone else having this problem?
I see from the board that there haven't been any replies for a few days...
Jarlath O'Grady
mailto:jogrady@swynk.com
http://www.swynk.com/friends/ogrady
Hi everyone
I want to know if it's possible to do a for/while-loop so i can use INSERT
Look:
I've this int [] test = new test[140];
But i need to insert for every value (140) a number
so normally it would be :
INSERT ... (case1, case2, case3 ...) value (test[1],test[2],test[3] ...)
But isn't there a way to it with a loop?
SOmething Like this ?
for( int i = 0 , i< 140, i++) {
INSERT case[i] value test[i]
}
Thanks in advance
Jonas
Can it be possible to create trigger/procedurein following case2 server server A and server BA has db1db1 has tblAB has db2db2 has tblBcan it be possible to create trigger on server A.db1.tblA asinsert/update that trigger add/update record in server B.db2.tb2thnks-----------Hitendra
View 3 Replies View RelatedI have set up a data driven subscription for a report, and against "Reply-To" I have selected "Specify a Static Value".
I have then I have entered a valid email address.
When the report is received however, and the recipient clicks reply, the reply address is filled in as the Email Address from which the report was sent.
Is this a bug with the "Reply-To" functionality? Or do I have to do this a different way?
Thanks :-)
Kate
Is there a way to do this? When I have a further question in the same thread, my only option is to reply to the one who answered the last question. How do I put forward that question to everyone? Do I have to start a new thread with the same subject?
thx
Kat
I'm trying to import data into an SQL Server (7.0) and I'm wondering which Source (Microsoft Data Link, Microsoft ODBC Driver for Oracle, Microsoft ODBC Driver for SQL Server, etc.) -- I THINK we would use the SQL Server driver but I'm not sure... to use AND WHERE TO GO FROM THERE? So far, I get seem to get things to work in my favor. I appreciate any help :) The data I'm trying to import is from Microsoft Excell. If there is anything else you need to know, please email me at iami@iami.org Please provide email/forum-based technical support.
View 4 Replies View RelatedThanks for the replies but...
I doesn't work!!!!
Anymore ideas?
---------------------------------------------
Hi,
I have a rather odd problem that hopefully you'll be able to shed some light on (nobody else has come up with anythig sensible).
We want to back up the databases to a hard drive held on another server so I mapped the drive in explorer to the drive then went into Enterprise manager and tried to create a backup device and it won't see the mapped drive.
I've tried mapping to my PC and I can see that via enterprise managers backup stuff (infact any PC in the office works) but it won't see any of the servers even though we can map to them and access them via windows explorer.
I've tried when logged on via sa and the windows NT administrator and still no luck. In fact no matter what I type or do it fails and keeps telling me device error or device off line which it isn't.
On our test instance of SQL Sever we can backup to other servers but not the new live version!
Any thoughts on what might cause this to happen?
Helen