20 reputation
4
bio website
location Czech Republic
age
visits member for 9 months
seen May 20 at 8:16
stats profile views 10

I'm a student of GIS , who has a hobby programming.

General interests: GIS, C#, SQL Server 2008, ArcObjects, WPF, Silverlight


May
6
comment How to create table set from several XSD in SQL Server 2012 or with VS 2012
Thank you for your help, I hope one of the answers will help. Unfortunately I cannot use XSD2DB because it throwing me an error - System.Data.DataException: DataSet Object doesn´t support list and union attributes of element simpleType.
May
5
comment How to create table set from several XSD in SQL Server 2012 or with VS 2012
I´m looking for the best way, how to convert my XML files into the MS SQL tables, and I thought that XSD and XML schema files will help me with definitions of the tables. But as I see, I´m totaly out of topic
May
4
revised How to create table set from several XSD in SQL Server 2012 or with VS 2012
added 381 characters in body
May
4
comment How to create table set from several XSD in SQL Server 2012 or with VS 2012
I have access to SQL server 2012 with full permission for managing database, so I´d like to prefer T-SQL, but if there won´t be any other choice I will use C#. The database will be used as a local database of the exchange format of addresses and real estates, so the first step is populate database from XML The second step is update database every week from other XML files
May
4
asked How to create table set from several XSD in SQL Server 2012 or with VS 2012
May
3
awarded  Editor
Sep
21
awarded  Custodian
Sep
5
accepted SQL Server : how to drop all constraints on a table in T-SQL
Sep
4
asked SQL Server : how to drop all constraints on a table in T-SQL
Sep
3
awarded  Scholar
Sep
3
accepted How to automatically regularly a week backup SQL Server database if changes exist in the database for the previous week
Sep
3
comment How to automatically regularly a week backup SQL Server database if changes exist in the database for the previous week
I think I can handle it with MSDN :-) Thanks a lot!
Sep
3
comment How to automatically regularly a week backup SQL Server database if changes exist in the database for the previous week
It´s very small. Only 8 tables, with 50 rows in each table.
Sep
3
comment How to automatically regularly a week backup SQL Server database if changes exist in the database for the previous week
@Edward Dortland - Thank you, for quick answer. About my database skills - I´m not new in SQL, but this is my first time, I want to administrate MSSQL. This question is last step of my school project for. I have a program C# which read and write data to SQL DB. Originally I thought about backup DB from program when user will updating the DB, but at last I don´t want to burden DB in every update, so I decide to use some automatic procedure or something like that for automatic backup in side of server.
Sep
3
asked How to automatically regularly a week backup SQL Server database if changes exist in the database for the previous week
Aug
25
awarded  Student
Aug
25
reviewed Approve suggested edit on SQL Server 2008 R2 - Weekly / Monthly Statistics
Aug
24
asked SQL Server 2008 R2 - Weekly / Monthly Statistics