|
hi,
i have a trigger on a table and in the trigger i want to RAISE an ERROR and also log the error into a table..
The error works fine (it is raised) but it seems there is no record in my logTable. i suppose the complete transaction is rolled back, including my insert into my logtable.
any idea how i can solve this problem can i exclude my insert into my logtable from the roll back ?
thx
Kurt
|
|
|
|
|
The normal way to do this is to insert the item into the log table inside a different transaction.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Thx for the response,
so this means i can't do it inside the trigger ?
if the [After] trigger raises an error it rolles back al the previous actions. including the insert in the table (A) ... and including the insert in the error log table (B).
i suppose there must be a way to log errors in triggers on tables... without using an application but straight from the database server.. our i must use a stored proc to insert into my table (A) (the one that has a trigger) by using begin try and begin catch
Thx
Kurt
|
|
|
|
|
i am not getting how to generate a data set and configuration wizard of data adapter
Plz let me know the procedure for retrieving records from database using sql statement
|
|
|
|
|
Use it....
Dim CnnString as String ="server=serverIp;uid=test;password=test;database=yourdatabase"
Dim Cnn as new System.data.SqlClient.SqlConnection(CnnString)
Cnn.Open();
Dim AD as new System.data.SqlClient.SqlDataAdapter("Select * From TableName",Cnn)
Dim DS as New DataSet
AD.Fill(DS)
Cnn.Close()
For each Dr as DataRow in Ds.Tables(0).Rows
Msgbox(Dr("column1")
Msgbox(Dr("column2")
......................
.........................
next
Parwej Ahamad
g_parwez@rediffmail.com
|
|
|
|
|
I have an SQL datasource hooked up to a stored procedure. I am succesfully retrieving data and showing it in a data list. I would like to make the data list sortable. I have created links in the header section of the datalist and these also succesfully trigger events. I have also built the stored procedure to accept a sort parameter which would allow the results to be sorted on any criteria.
Ok so I have everything set up and working that I need. My problem now is how, on triggered sorting events, do I alter the sqldatasource, to pass the sort parameter back to the database. I have played with the SortParameterName="" property to no avail.
Thanks in advance.
|
|
|
|
|
If you switched to using a datagrid or better yet a gridview there is an allowsorting property to the gridview. Then all of the sorting is just done for you. I don't use datalists a lot, but if you need to use it I am guessing that you would have to do some manual binding to get sorting to work.
Hope that helps.
Ben
|
|
|
|
|
Yeah I am well aware of the Gridview and it's automatic sorting and paging features but it has the obvious constriction of having to use columns. In this case each row in my table has a nested table inside it which also needs to have sorting applied to it. There are also TD's that stretch over multiple TD's. Therefore a grid view would be inappropriate so I have had to use Datalist.
The thing is I wanted it to use the SQLDATASOURCE to pass the ORDERBY value to my SP just like the Grid View would do automatcally for you. I managed using the article above. You just need to create your own link buttons and rig them to set an ORDER BY value. Then simply databind the datalist, ensuring that the bind uses your sorting parameter and bobs your uncle youv got the exact same functionality.
Works a treat espceially with an UpdatePanel around it too!!
|
|
|
|
|
Hello
I am using Sql Server 2005.
I have two different servers.
I was trying to use the wizard of Copy Database in order to copy a DB from one server to the other.
After arriving to the last stage where the copying process starts, I get an error in the field of
Execute SQL Server Agent JOB : The job failed. Check the event log on the destination server for details.
and on the destination server in the event log I get the message :
Package "CDW_DT-A1_MLS09_1" failed.
where DT-A1 is the source server and MLS09 is the second server.
Anyone has ideas how to overcome this problem ?
Thanks,
Clint
|
|
|
|
|
You may want to check what you are trying to copy. For instance, if you try to copy a database user/role across - this might be causing it to fail.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Hey
Thanks for helping.
I don't think that is the problem.
Can you see any other reason ?
I think that the server which I am trying to copy to has an older sqlserver 2005.
How can I do the copying ?
Clint
|
|
|
|
|
hi,
i am having 2 tables (SQL 2000) on 2 different servers (windows 2003 server). now i have to run some inner join on both the tables. i tried by giving
select * from servername1.databasename.dbo.tablename kind of statements in the servername2. but it throws errors. kindly suggest.
thanks
|
|
|
|
|
|
hi all,
I am using MSSQL 2005.
I want to backup my database from the server.
the problem is server is remote.
I can only access the server through "SQL studio management express"
How can i back up the database.
i want the full table with data and SP also
All I ever wanted is what others have....
CrazySanker
|
|
|
|
|
As long as you can connect to the database using SSMS you should be able to back it up. The only problem is you won't be able to create the backup on a local drive. You'll have to save the backup to a drive which is on the actual SQL Server instance. Then you'll need to download the backup if you want to have it on your local machine.
To backup a db from SSMS, just right-click the database and select Tasks - Backup... If you create a full backup you'll get all data and tables.
If you're having trouble connecting, creating the backup or downloading a copy of the backup you'll need to contact the administrators in charge of the server where your database is located. They can help you connect and get a backup.
|
|
|
|
|
Hi,
I have to write a common method to bind the sql parameters to the placeholders in the input sql statement.
The sql statement is given as input to the common method and the array of parameters are also given as input..the values should be bind to the placeholders and the resulting sql statement shld be the output...
public string bindSqlParams(string strSql, object[] arrData)
{
}
We can also pass the command object if needed for implementation..please help me with the implementation of this common method..
Thanks in advance...........
|
|
|
|
|
I am creating one stored procedure in which i'm sending group of queries like,
SELECT * FROM TABLEA;AND;SELECT * FROM TABLEB
and i want slipt this input with delimiter ;AND;
means i want seperate the queries.
1. SELECT * FROM TABLEA
2. SELECT * FROM TABLEB
please anybody help me.
Regards,
PVC
|
|
|
|
|
Hi
May be you are trying like this:
Use Northwind
Go
DECLARE @sql nvarchar(2000)
SELECT @sql = 'SELECT * FROM Products;and;SELECT * FROM Region;and;SELECT * FROM Invoices;and;'
SELECT @sql = REPLACE(@sql,';and;',' ')
exec (@sql)
Rate this message. Thank you. Harini 
|
|
|
|
|
|
It's good but I need separated queries to be stored in variaable or in temp table as record.
I hope you will help me.
|
|
|
|
|
Hi
Try this:
Use Northwind
Go
DECLARE @sql nvarchar(2000)
SELECT @sql = 'SELECT * FROM Products;and;SELECT * FROM Region;and;SELECT * FROM Invoices;and;'
SELECT @sql = REPLACE(@sql,';and;',';')
DECLARE @theString varchar(4000), @separator char(1)
DECLARE @seppos INT
DECLARE @curval VARCHAR(4000)
SET @theString = @sql
set @separator = ';'
WHILE PATINDEX('%' + @separator + '%' , @theString) <> 0
BEGIN
SELECT @seppos = PATINDEX('%' + @separator + '%' , @theString)
SELECT @curval = LEFT(@theString, @seppos - 1)
--> use this variable for inserting into a table
PRINT 'Select Tables: ' + @curval
SELECT @theString = STUFF(@theString, 1, @seppos, '')
END
Rate this message. Thank you. Harini
|
|
|
|
|
Perfect! this is what I expected.
Thank you very much, Do u have any blog site so that i can reach easily.
Once again thanks.
PVC
|
|
|
|
|
Harini311 wrote: I dont have blog site.
What the... You can blog here[^]
Nobody can give you wiser advice than yourself. - Cicero
ப்ரம்மா
|
|
|
|
|
how to give DBO permissions to ASPNET_ tables that are created when I used the Login control supplied in visual studio. I created the tables on the SQL Server and pointing my login controls to those tables. But I get an error about DBO rights
please help
Raj D
|
|
|
|
|
Hi,
i have two tables with a 1:n relation. I insert a new row in the first table without knowing the id of it, because of a trigger in the table. Now i want to insert a bunch of rows in the second table, but i need the id of the before inserted row because of the foreign key.
How could i do that?
I use a firebird embedded db with .net + C#
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
