|
If you are just adding new records then you might want to try adding "where 0 = 1 " to your select statement. That way it won't try to read the full contents of the SQL-Server table into your PC's memory.
|
|
|
|
|
Perfect! It flies now! Thanks!
|
|
|
|
|
I am trying to take Backup and Restore Using VB.NET or C#.NET
Can you please help me how to do.
With code snippet.
Yugan
|
|
|
|
|
There are no ADO.Net commands/methods which perform a backup. But you can submit a query using an ADO.Net command to perform a backup or restore the same way you would submit a SELECT, INSERT, UPDATE or DELETE query to the server. Your best source for syntax would be SQL Server Books Online (aka BOL). Here's a quick snippet to get you started (C#):
<br />
using(SqlConnection conn = new SqlConnection("connection string here")){<br />
SqlCommand cmd = new SqlCommand();<br />
cmd.Connection = conn;<br />
cmd.CommandText = "BACKUP DATABASE [datbase name here] TO DISK = N'file path and name of backup here'";<br />
cmd.CommandType = CommandType.Text;<br />
<br />
conn.Open();<br />
<br />
cmd.ExecuteNonQuery();<br />
}<br />
Just make sure that the file path of the backup is a path which exists on the server where SQL Server is installed. You may also want to set the CommandTimeout property if the database is very large.
|
|
|
|
|
Hi
How to find foreign key for a given table in sql server 2005.
exec sp_fkeys @pktable_name='authors' //It is working fine in sql 2000
But the same is not working for 2005.
exec sp_fkeys @pktable_name='[Production].[Product]'
also I tried
exec sp_fkeys @pktable_name='[Test].[Production].[Product]'
Can any one help me please
kesavan
|
|
|
|
|
Try this:
sp_fkeys @PKTable_name = N'Product', @PKTable_owner = N'Sales'
(This, of course, assumes that you have a product table in a Sales schema).
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Thanks a lot pete
kesavan
|
|
|
|
|
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
|
|
|
|