Database

If your datasource for the datagridviews is the same then naturally the data is the same. You can separate the datasources into bindingsources or copy the dataview to a new table for each datagridview. BTW this should be in the Windows Forms forum. Never underestimate the power of human stupidity RAH

Thanks Abhishek Sur. I'm using LINQ, so I've used the following code : public static void GetBackUp() { if (!Directory.Exists(StaticVariables.BackUPFolder)) Directory.CreateDirectory(StaticVariables.BackUPFolder); using (RezaRestaurant.SQL.DataClasses1DataContext dbc = new RezaRestaurant.SQL.DataClasses1DataContext()) { dbc.ExecuteCommand(@"BACKUP DATABASE " + dbc.Mapping.DatabaseName + " TO DISK='c:\\aaa.bak'");//Exception } } and this Exception has occurred : http://www.codeguru.com/forum/attachment.php?attachmentid=25454&d=1253973435[^]

thanks :rose: Syed Shahid Hussain

Blikkies, Thanks for the info. Just a couple follow up questions. So on the 2005 SQLExpress Server I have an instance of SQLEXPRESS and on 2008 SQL I have an DB instance of MY2008DB I would do the following if I am running on the 2008 system. EXEC sp_addlinkedsrvlogin '\\MY2005Server\SQLEXPRESS', 'false', 'sa', 'sa', 'sa' SELECT INTO [MyDatabase2].[dbo].[mytable] FROM [\\MY2005Server\SQLEXPRESS].[Mydatabase1].[dbo].[mytable] and if I was running this on the 2005 server it would be the opposite ? EXEC sp_addlinkedsrvlogin '\\MY2008Server\MY2008DB', 'false', 'sa', 'sa', 'sa' SELECT INTO [\\MY2008Server\MY2008DB].[MyDatabase2].[dbo].[mytable] FROM [Mydatabase1].[dbo].[mytable] Or how does that work with the DB Instance name ? thanks

And that'll preserve all my access control and so on? OK, thanks - will do.

simple just do it gv.Cloumns["YourColumnsName4hide"].Visible = False that's it Syed Shahid Hussain

Bah...at first glance I thought this was unanswered....in any case, drop the '' inside your IN and give it a list of separate values - sounds like that's already fixed ya right up... -Dave

OK, so your DB started performing poorly after it ran for awhile....that's a pretty broad problem, but here's a few things you might try: 1) I fully agree with Bob's post - if you want it to work correctly, get someone who knows what they're doing to set things up properly. (Though I understand that doesn't fix your problem today.) 2) Check for any tables that have grown excessively large. It's possible that you have some large logging / history tables and such that can easily be archived and deleted from the working tables. 3) If there's any way to narrow your problem down to a few areas (perhaps the top 2 or 3 stored procedures you're having trouble with?) you can look at modifying indexes specifically to help with those queries - just be sure you don't replace one problem with another. 4) You could always throw more hardware at it for a temporary fix... If you have any more specifics about what the problem is, perhaps we could better help. -Dave

Thanks, Bob...just wish there was a different answer. The more I think about this though, it just seems that there really should be some way to do a sub-query against a stored proc's result set from SQL Server management studio without having to define specific tables, or do anything funky like parsing the SP to auto-create a result table. Perhaps I just need to add this into a feature request for MS. Just in case...anyone else have a suggestion on how to narrow down the results of a stored proc from within Management studio? Something like being able to run a query against the results window sure would be handy. Thanks, Dave

You can even do what abishek said, with a simple batch file, and a scheduled task. My advice is free, and you may get what you paid for.

ohh sorry i dont know...i don't do it intensionally

Yes, it does. :)

Member 3108667 wrote: but multi-user ready, about 10 users I would go for SQL Server (Express). This gives you the chance to extend your application to n folds in future with no effort in programming and by just changing the express version to the proper SQL Server. Hope this helps. :) Manas Bhardwaj Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

step 1 : create a Table types named "DIVISION_ARRAY" CREATE TYPE "DIVISION_ARRAY" AS TABLE OF VARCHAR2(12) step 2 : execute the below procedures CREATE OR REPLACE FUNCTION "UNPACKDIVISIONARRAY" (Source IN VARCHAR2 DEFAULT NULL, Delimiter IN CHAR DEFAULT ',') RETURN division_array PIPELINED IS l_list varchar2(32767) := Source; l_idx pls_integer; l_value varchar2(32767); BEGIN loop l_idx := instr(l_list,Delimiter); if l_idx > 0 then pipe row(substr(l_list,1,l_idx-1)); l_list := substr(l_list,l_idx+length(Delimiter)); else pipe row(l_list); exit; end if; end loop; return; end UNPACKDIVISIONARRAY; step 3 : execute the below sql to see the result Select column_value from TABLE(UNPACKDIVISIONARRAY('111,113')) hope that this will help you. regards, Sumith Koshy Thankan, OASYS Information Technology. Dubai