|
hello everybody in this forum , i would like to ask about something .
i would like to use .net Remoting from sql server , that means i need sql server to notify a windows service about some transactions that occur in the db like insertion , update or deletion . i tried to develop a managed trigger via C# but when i refer to system.runtime.remoting.channels.http in the solution , it doesn't show me all available namespaces in the solution like any other .net solutions , so is there a way to let the sql server notify the windows service about some changes , thank you
Human knowledge belongs to the world.
|
|
|
|
|
Take at look at notification services[^]. I think it will do what you require.
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
hi all,
I want to fill multicolumn listbox from an recordset. How is this possible? Without using Getstring() of Recordset.
please suggest me another way.
Regards.
modified on Monday, February 9, 2009 7:06 AM
|
|
|
|
|
|
In a join which table is said Left, which one right?
It depends on List in select or order in On or ...
Best wishes
|
|
|
|
|
table1 left join table2 on table1.id=table2.id
here table1 is left table whereas table2 is right. Query return all record from table1 plus matches record from table2
table1 right join table2 on table1.id=table2.id
here table1 is left table whereas table2 is right. Query return all record from table2 plus matches record from table1
hope this clear your confusion
|
|
|
|
|
The left one is the one on the left of the join and the right one is the one on the right of the join.
That is in Left-to-Right text. I cant imagine how messed up queries would look in Hebrew (RtL)
|
|
|
|
|
See the following example:
Select table1.*, table2.*
From table1
join table2 on table1.Id = table2.Id
In the above example table1 is considered left and table2 is considered right.
|
|
|
|
|
Dear All,
I need to reduce the log file size...
I've created a maintenance plan for shrinking the DB in my local machine, I've created every thing ok and scheduled it to work daily. and when I right click and then execute, the dialog displays successful process, but when I check the DB Log, it still huge size (about 20 Gb). I do not know why the log file size still huge after shrinking the DB.
Any help, plz???
Kind Regards
OBarahmeh
|
|
|
|
|
Did you try gogole search?[^]
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
Ok, I've found the solution:
USE yourDB;
GO
-- Truncate the log by changing the database recovery model to SIMPLE.
ALTER DATABASE yourDB
SET RECOVERY SIMPLE;
GO
-- Shrink the truncated log file to 1 MB.
DBCC SHRINKFILE (yourDB_Log, 1);
GO
-- Reset the database recovery model.
ALTER DATABASE yourDB
SET RECOVERY FULL;
GO
Kind Regards
OBarahmeh
|
|
|
|
|
Hi Guys
I have a query that I am using to build a report in SRS 2005. The query sorts records by Customer ASC. When I view the query in SRS 2005 it is still sorted correctly. I have a group by Customer in the report. If I view the Report, my records comes back totally out of order. I also tried to force a sort by using the group properties and setting the sorting to customer, but still no luck.
Can someone please tell me how I will be able to get this records sorted properly? I will really be greatfull for your help.
Kind Regards,
Elizma
|
|
|
|
|
Can you put query or any example
|
|
|
|
|
Hi,
Thanks for the willingness to help. I dont know what the problem was, but I deleted the report table, recreated it and then it worked fine.
Elizma
|
|
|
|
|
|
Hi mates , i am a new joinee...need guidance .....it's a SOS...
These days i am busy implementing Data Mining/Data Warehousing issues for clients.I am facing a critical issue regarding Ab Initio.
I need guidance regarding it's licensing issues and comparitive analysis with other ETL products...
|
|
|
|
|
|
Your image link doesn't work.
Can you post your error message or post once again your image error.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
|
How you try to connect in that sql server? Remotely? If yes then that Server must login with username SA and password SA.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
SQL server does not exist or access denied.
What part of that error message is unclear? 
|
|
|
|
|
|
thx for all
the problem was solved
BESHOY
FACULTY OF COMPUTER AND INFORMATION
COMPUTER SCINCE DEPARTMENT
|
|
|
|
|
Hello all,
I have a table in which I have added new one column and now I want to add data to it. What I want is that column starting values should be from some number and end with the number of rows.
Like if I have 1000 records in by table then I want this column to have values from 2200 to 2200 + 1000.
I hope I made myself clear.
Please help me.
Thanks in advance.
|
|
|
|
|
declare @newValue as int<br />
set @newValue = (selex max(colname) from tablename)<br />
<br />
insert into tablename ColumnName <br />
values (@newValue+1)
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
