|
hi..
i would like to attach OR RESTORE a database TO MSDE USING VB.NET OR C#.
PLZ HELP ME OUT TO SOLVE THIS PROBLEM...
THNKS & RGDS
AGEESH
|
|
|
|
|
I would help but I have never used MSDE, isn't this a forerunner to sql server express? Looks like some likely responses with this search[^]
|
|
|
|
|
Hi,
I am using sqlserver 2008, How can I calculate the total memory occupied by the Database with tables (>30) and also data in it.
I mean if I have DB (DB_name) and with few tables(tblabc, tbldef......) with data in it, how to calculate the total memory occupied by the database in the server.
Kindly Help me.
Thanks
Ramm
|
|
|
|
|
Like this:
use YourDBName
SELECT size FROM sys.database_files
It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD
|
|
|
|
|
Hi D@nish,
I executed the query, it showed, 1408 and 2768 without data in database.
even with data it showd the same numbers.
please help me.
Thanks
Ramm
|
|
|
|
|
Well have a rat around the management studio, sysobjects also has lots of info.
Take a look at the system views, they are design to give you info on your databases.
|
|
|
|
|
Right Click your database in Object Explorer, Select Reports - Standard Reports - Disk Usage
explore these reports for common reqs.
I don't speak Idiot - please talk slowly and clearly
I don't know what all the fuss is about with America getting it's first black president. Zimbabwe's had one for years and he's sh*t. - Percy Drake , Shrewsbury
Driven to the arms of Heineken by the wife
|
|
|
|
|
Size is the size of mdf and ldf file in 8K pages. Divide the value by 128 to get the size in MB.
It might come same with/without data depending upon the amount of data your DB holds.
It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD
|
|
|
|
|
Hi,
Hi,We are migrating our DB from MS Access to SqlServer 2005. So could anybody please let me know how to copy the data in MS Access tables, first to an XML file and then to a table in Sql Server 2005, using C# as programming language and .NET 2005 as platform.
Thanks & Regards
Puneet
|
|
|
|
|
What happenned to your migrate from Access to SQL - what you are trying is not the best way of doing it.
If you assume that SQL Server can read a datatable written as an xml file you could read the table into the client C# and wtrite it out using datatable.writexml(filename)
|
|
|
|
|
i've installed sql server in windows authentication.I want to change the authentication mode to sql sever..How can i do this without reinstallation?
|
|
|
|
|
I thoight that was a setting on the database not the server - nope just checked.
I can change it in Management studio 2005+, you may need to use a script to change it in 2000. Can you right click on the server in QA and get the properties of the database?
|
|
|
|
|
Start 'SQL Server Enterprise Manager"
Right click on your server and choose properties
Select the Security tab and do you configuration.
Wout Louwers
|
|
|
|
|
Hi,
We are migrating from MS Access to SqlServer 2005. Could anyone please let me know how to copy tables and other objects (Stored procedures, triggers) from our current Access Database to SqlServer 2005.
Thanks & Regards
Puneet
|
|
|
|
|
This is how it is being done in sql server 2000.first from enterprise manager right click on the database.
2)choose new database and create a new database with the name of your sql server database.
3)Right click on the new database created and from tasks choose import data.
4)A dialog box will appear.you have to specify the datasource there,which is microsoft access in your case.Then just follow the instructions and you will get your database migrated.
|
|
|
|
|
hi
i want 2 update this record
EMP_ID SHIFT DEPT OVERTIME TIME_DATE
1 General IT 6 19-AUG-09
when i update this record then overtime add in 6 means i add 2 so overtime is 8.
how can i do this???
thanks in advance.
|
|
|
|
|
General form: update TABLENAME set FIELDNAME = VALUE where WHERECLAUSE
eg:
update tblEmployeeOvertime set Overtime = Overtime + 2 where Emp_ID = 1
|
|
|
|
|
how to send captured WireShark packets to sql database
|
|
|
|
|
Like this:
1. Parse the information.
2. Split the information into bite-sized pieces that match your table structure.
3. Use SQL (or a Stored Procedure) to insert the information.
4. Repeat until you have no packets left to process.
|
|
|
|
|
so i saved the packets to a excel file. from here i want to write a code that would let me read from that file and send that data to the database but am having problems writing that code to do this .., do you have any reading material on how this can be done
|
|
|
|
|
Last night I wanted to copy an Access 2007 .mdb file and the thing was 618 MB ! I know that there is no way there could be that much data, so I did a compact & repair and the size went down to 6 MB.
The other interesting thing about this .mdb is that there is actually no user data stored in it. It contains just the forms, queries, reports, modules. It references the data tables stored in a separate .mdb via linked tables.
What could have caused this to grow to such a large size ? I never had this problem with Access 2003.
I really can't stand any of the Office 2007 products.
|
|
|
|
|
Why is it so? Because Access doesn't do garbage collection or cleanup particularly well.
Usually, your file will swell rapidly if you are creating temp tables through code or make-table queries.
Since you say it's your front end, one way to combat this issue is to have it compact and repair on exit.
|
|
|
|
|
This problem has been around for ages - I remember having a compact method in access 97, the user could check the size via a form and would decide when to compact the database.
This is one of the (minor) reasons to move to a decant database platform.
|
|
|
|
|
Mycroft Holmes wrote: decant database platform
Is that one that you pour from a bottle? rofl...
|
|
|
|
|
I build application in vb.net 2005. Now i want to deploy it through setup (build through setup and deployment project in vb.net),
I want to install sql server2005 express with my setup but this installation must be unattended (silent)
if anyone know, please help me and tell me the complete steps.
thanks
|
|
|
|