Database

And Another SQL Server Question (sorry 'bout that, Chief...)

20-Nov-09 20:38

You have a problem that is probably not solvable, CSV/Excel/MS converters use the " character as the text delimiter and probably wraps the entire text field in ". Embedded quotes are probably not going to be supported, certainly in CSV where it is a control character.

Never underestimate the power of human stupidity
RAH

Roger Wright19-Nov-09 18:15

Re: And Another SQL Server Question (sorry 'bout that, Chief...)

19-Nov-09 18:15

While doing a little maintenance on a database that keeps track of reclosers (devices used in electrical substations), I tried adding a field to a table using the Management Studio on the server. No go - I don't have permission, and have no idea where to change that. So I switched to the client, opened Visual Studio, connected to the same database on the server, and proceeded to add new fields without a problem. In both instances I was logged in as the same domain user, with admin priveleges. It's not intuitively obvious to me why a remote user using Visual Studio has access priveleges greater than an administrator on the local server using the management tool designed for SQL Server. Can someone explain this odd behavior? I really think - especially once I complete an app to use this data - that this situation should be reversed, but I have no idea how to do so.

Thanks! Big Grin | :-D

"A Journey of a Thousand Rest Stops Begins with a Single Movement"

Vimalsoft(Pty) Ltd19-Nov-09 20:01

Re: And Another SQL Server Question (sorry 'bout that, Chief...)

19-Nov-09 20:01

i understood the first part of your question but got lost in the last question. First Question when you logged into SQl management Studio did you use Windows Authentication to log in ? if yes, your user did not have permission. log in as a "sa" user or a user that has sysadmin permission in that sql instance and add the domain user and give him appropriate permissions and you will be able to add the field there. Your Resolution was to go the VS route which is not a good idea in most cases.the Reaons that you were able to add the field was that someone with permissions once created that and now it is always there it does not even ask you for username and passowrds, you just use it. i used to do that too. The last part of your question i did not understand

It's  not intuitively obvious to me why a remote user using Visual Studio has access priveleges greater than an administrator on the local server using the management tool designed for SQL Server. Can someone explain this odd behavior? I really think - especially once I complete an app to use this data - that this situation should be reversed, but I have no idea how to do so.

Vuyiswa Maseko,

Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code.

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

Roger Wright20-Nov-09 2:08

Re: And Another SQL Server Question (sorry 'bout that, Chief...)

20-Nov-09 2:08

Thanks, but I think Shameel has hit the nail on the head. Smile | :)

"A Journey of a Thousand Rest Stops Begins with a Single Movement"

Vimalsoft(Pty) Ltd20-Nov-09 2:09

Re: And Another SQL Server Question (sorry 'bout that, Chief...)

20-Nov-09 2:09

Cool

Shameel19-Nov-09 23:04

Shameel

19-Nov-09 23:04

If you are very sure that you used the same credentials in both instances, then it could be a setting in SSMS that prevents changes to tables that require the table to be recreated.

Click Tools --> Options
Under Designers --> Table and Database designers, there is an option "Prevent saving changes that require table re-creation".

Ensure that this option is unchecked. It is checked by default.

Re: And Another SQL Server Question (sorry 'bout that, Chief...)

Roger Wright20-Nov-09 2:03

Re: And Another SQL Server Question (sorry 'bout that, Chief...)

20-Nov-09 2:03

Thanks!

I generally don't mess with default settings until I'm familiar with the product, and that's one I haven't changed.

"A Journey of a Thousand Rest Stops Begins with a Single Movement"

Corporal Agarn20-Nov-09 7:56

Corporal Agarn

20-Nov-09 7:56

Had the same problem today. I am getting into 2008 from 2000 and did not know where to find that setting.

Thanks Shameel

by the way I just noticed the Get Smart quote Laugh | :laugh:

djj

Yet Another SQL Server 2008 Question

Roger Wright19-Nov-09 17:48

19-Nov-09 17:48

I'm on a roll here, so bear with me.

I haven't used it before, and want to learn it quickly. I particularly want to use it with C# applications for tracking equipment and service records for work. I also happen to have a few bucks available and I'm in the mood to buy myself a Christmas present. A book would be nice, particularly a book that covers programming for SQL Server 2008 in C#, and which will also teach me about n-tier development - breaking the task into logical units for data access, business rules, and user interfaces. I tend to get them all muddled together in one mess, and you know what that leads to... another project I never finished. I'd like to be done with that, once and for all.

Any favorites?

"A Journey of a Thousand Rest Stops Begins with a Single Movement"

Vimalsoft(Pty) Ltd19-Nov-09 20:08

Re: Yet Another SQL Server 2008 Question [modified]

19-Nov-09 20:08

well that will be nice if you can buy a Book, i will recomend one for beginner. well am writting one that takes the N-Tier route. you can check my articles

http://www.codeproject.com/script/Articles/MemberArticles.aspx?amid=3942021[^]

and i have a friend who wrote a nice book that will get you started in N-Tier , you can buy yourself this one

http://www.allbookstores.com/book/9780470187593/Beginning_ASP_NET_3_5_In_C_and_Vb.html[^]

Hope this Helps

Mycroft Holmes19-Nov-09 21:07

19-Nov-09 21:07

I just happen to have this handy that may be of interest

[edit] As Shameel pointed out these may be illegal books and I respect and appreciate the work put in by authors to encourage theft. [/edit]

Last modified: 2hrs 26mins after originally posted --

Shameel19-Nov-09 23:08

Shameel

19-Nov-09 23:08

CP is a place for ethical programmers. Do not post links to illegal free ebooks Thumbs Down | :thumbsdown:

Mycroft Holmes19-Nov-09 23:37

19-Nov-09 23:37

I did not even look into the details, I got the link right here and thought they were teaser type books, thanks for the heads up. I agree with you and the authors put in way too much effort for me to devalue their work by encouraging theft.

Roger Wright20-Nov-09 2:06

20-Nov-09 2:06

I appreciate your conern, and agree with you about IP theft colpletely, but if you couls at least post the title, I might be able to actually buy it. Big Grin | :-D

"A Journey of a Thousand Rest Stops Begins with a Single Movement"

Shameel20-Nov-09 2:37

Shameel

20-Nov-09 2:37

"Pro ASP.NET for SQL Server: High Performance Data Access for Web Developers" by Brennan Stehling.

Roger Wright20-Nov-09 13:49

Documenter for SQL Server 2008

20-Nov-09 13:49

Great! That's a good start, I think, although I don't plan to use web access yet - just a dedicated C# client accessing a central SQL server in the office. My whole plan is to make this equipment tracking job so simple I can hand it off to someone else. Big Grin | :-D

"A Journey of a Thousand Rest Stops Begins with a Single Movement"

Roger Wright19-Nov-09 17:39

Re: Documenter for SQL Server 2008

19-Nov-09 17:39

Is there such a thing? Access ships with a built in documenter, which I find handy in print form to use as a reference when I'm trying to wrote code to manipulate it. I never can remember all the field names and types 20 minutes after I create a database...

I can get a list of field names using a select query against 'information_schema.columns' and I can print that, but it's not a very convenient format; all I want is the field name, type, and width (for text).

Is there a freely available tool to simplify this task?

"A Journey of a Thousand Rest Stops Begins with a Single Movement"

David Skelly19-Nov-09 22:35

David Skelly

19-Nov-09 22:35

There's an article right here on the Code Project which might help:

SqlDoc: Document your SQL Server database[^]

Or, a quick google for "sql server free schema documentation tool" brings up over 85,000 results, at least one of which might be helpful.

DBScribe is good, although it's not free. But at just $99 it's not exactly going to break the bank. It might be overkill for what you're looking for, though.

Convert a 2008 SQL SERVER MDF info 2005 !

mrkeivan19-Nov-09 9:57

mrkeivan

19-Nov-09 9:57

Hey guys, as u guessed by now, I have a MDF and LOG file which were created in SQL Server 2008, and currently I don't have that. Is there anyonre who can give me an email address so I can send my files to him and he sends me the script, that way I can generate it in 2005 !!! I ve done alot of searching and found this as the only way !!!

Thanx in advance

Vimalsoft(Pty) Ltd19-Nov-09 20:12

19-Nov-09 20:12

Am trying to understand what your question.its not clear please try to explain again

mrkeivan20-Nov-09 4:54

mrkeivan

20-Nov-09 4:54

I want to send someone an MDF and LOG file, have them attach the file to their server, then script out the entire database and return the script to you.

Mycroft Holmes19-Nov-09 21:03

19-Nov-09 21:03

You want to send someone an MDF and LOG file, have them attach the file to their server, then script out the entire database and return the script to you.

You might want to elaborate, the size of the database would be rather important.

Also, why not install SQL Express 2008 and do it yourself (other than the absolute nightmare that installing SQL 2008 is).