Mcdba

Hi
I am wanting to take the 70-228 and 70-229 exams. Does anyone who has already passed them have any recommendations for the best / most complete books for studying them? Opinions seem so varied on Amazon...
Thx
Deshai desmondx,

Last week i cleared my 70-229 exam and i am taking 70-228 exam this next week.

In my opinion, Microsoft Training Kits will really help u for the exam. What u need is a little handson experience in SQL Server and Mircorsoft Training Kit for preparation and use Books online for indepth explanation and reference. U can easily get a good score in the exam.

I also used Inside SQL Server 2000 from MSPress

Guides from testking are also useful but don't rely only on them.

I have heared that self-test softwares r good. (but i hav'nt used any of them)

All the best for ur exam

With regards
Sudar|||Thanks for the advice Sudar,

Good luck with 228...
:-)
cheers
des

May I have your purmisshun?

Hi;

I'm a novice, and I need to set permissions in SQL Server 2005 (with Server Mgmt Studio)
so that I can create, modify, and delete tables in a database through my ASP.NET application.
I can't seem to find anything that spells this out - step-by-step - so that any idiot can follow it.

This is my error message:
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
### Exception Number : 262
### (CREATE TABLE permission denied in database "MyDBase''.)
### Message: CREATE TABLE permission denied in database "MyDBase''. Number: 262
### Procedure: Server: SYS-EML8V3\SQL2005D01
### Source: .Net SqlClient Data Provider State: 1 Severity: 14 LineNumber: 1
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Does anyone have a link to something that might give me a clue?

THANKS!

Well, use some kind of tool, for example,Microsoft SQL Server Management Studio Express, and give to your user used in connection string appropriate right:

(under Databases -> Your Database -> Security -> Users)

|||

Dejan Vesic:

Well, use some kind of tool, for example,Microsoft SQL Server Management Studio Express, and give to your user used in connection string appropriate right:

(under Databases -> Your Database -> Security -> Users)

Hi Dejan;

I tried this with the ASPNET user, but it didn't work - I got the same error.

I must be missing something. Is there another user that I'm supposed to be setting this for?

THANKS!

|||

wASP:

Dejan Vesic:

Well, use some kind of tool, for example,Microsoft SQL Server Management Studio Express, and give to your user used in connection string appropriate right:

(under Databases -> Your Database -> Security -> Users)

Hi Dejan;

I tried this with the ASPNET user, but it didn't work - I got the same error.

I must be missing something. Is there another user that I'm supposed to be setting this for?

THANKS!

UPDATE ...

I've given the ASPNET user the "sysadmin" Server role - and it seems to have worked.

My next question is: Have I done something stupid (in terms of compromising security)?

THANKS!

|||

The answer is yes you can use either DBO(database owner) which is still risky but less so than Sysdamin or DDL admin. Try the link below for details. Hope this helps.

http://msdn2.microsoft.com/en-us/library/ms189612.aspx

|||

Caddre:

The answer is yes you can use either DBO(database owner) which is still risky but less so than Sysdamin or DDL admin. Try the link below for details. Hope this helps.

http://msdn2.microsoft.com/en-us/library/ms189612.aspx

Hi Caddre;

I think I've gotten everything set OK now - thanks to yourself and Dejan - and the link to that article (which I will save).

THANKS AGAIN!

|||

wASP:

Caddre:

The answer is yes you can use either DBO(database owner) which is still risky but less so than Sysdamin or DDL admin. Try the link below for details. Hope this helps.

http://msdn2.microsoft.com/en-us/library/ms189612.aspx

Hi Caddre;

I think I've gotten everything set OK now - thanks to yourself and Dejan - and the link to that article (which I will save).

THANKS AGAIN!

I am glad I could help.

MaxLocksPerFile

Hi

I wrote a script in Installshield that changes the MaxLocksPerFile value in
Registry for Jet 3.x and Jet 4.0
While installing the application through Installshield, the custom value for
MaxLocksPerFile is being overwritten to 9500 in Registry for Jet
4.0(HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Jet 4.0) but not
for Jet 3.x(HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Jet 3.x).
The value is being overwritten to 9500 before the control reaches at the
script code.

I am wondering from where this 9500 value is being retrieved and set in
Registry.
Is there some file where these default values are mentioned.
If so then why 9500 value is not being set for Jet 3.x and is being set only
for Jet 4.0.

i am using MS Office 2002. Drivers for ODBC MS Access is above 4.0
and Installshield Version is 5.5.

Please help me to resolve this Issue.

-Regards
Harpreet

The default value for both Jet 3.5 and 4.0 is 9500.

If your installation script is causing Jet to be re-registered it will reset the values in the registry back to their defaults and over write yours.

The 9500 value was originally put in for Netware servers and typically you do not need to change it from its default pf 9500.

See page 611 of "The Jet Database Engine Programmers Guide" or futher searching of MSDN.

|||

Hi Joel,

Thanx for your reply.

Could you please let me know from where this default value of 9500 is retrieved and set the registry variable.

Could you please get me access to "The Jet Database Engine Programmers Guide" . I currently do not have this guide.

-Regards

Harpreet

|||

Here is a link to the book on Amazon:

http://www.amazon.com/Microsoft-Database-Programmers-Professional-Editions/dp/B00005TNX9

The registry is:

HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\Jet 4.0\MaxLocksPerFile

default is 9500

|||

Hi Joel

Thanks for the information.

Still I have one question: Is there some file (configuration file or so) from where this default value of 9500 is taken and set in to the registry.

-Regards

Harpreet

|||The registry value is created in setup or when registering msjet40.dll.|||

HI Joel,

Can we change this registry value during registering.We have _drivers.ini file which contains default values for arguments.I tried to set the custom value in that ini file, but during installation, registry value is again set to default value of 9500.

sql

MaxLocksPerFile

Hi

I wrote a script in Installshield that changes the MaxLocksPerFile value in
Registry for Jet 3.x and Jet 4.0
While installing the application through Installshield, the custom value for
MaxLocksPerFile is being overwritten to 9500 in Registry for Jet
4.0(HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Jet 4.0) but not
for Jet 3.x(HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Jet 3.x).
The value is being overwritten to 9500 before the control reaches at the
script code.

I am wondering from where this 9500 value is being retrieved and set in
Registry.
Is there some file where these default values are mentioned.
If so then why 9500 value is not being set for Jet 3.x and is being set only
for Jet 4.0.

i am using MS Office 2002. Drivers for ODBC MS Access is above 4.0
and Installshield Version is 5.5.

Please help me to resolve this Issue.

-Regards
Harpreet

The default value for both Jet 3.5 and 4.0 is 9500.

If your installation script is causing Jet to be re-registered it will reset the values in the registry back to their defaults and over write yours.

The 9500 value was originally put in for Netware servers and typically you do not need to change it from its default pf 9500.

See page 611 of "The Jet Database Engine Programmers Guide" or futher searching of MSDN.

|||

Hi Joel,

Thanx for your reply.

Could you please let me know from where this default value of 9500 is retrieved and set the registry variable.

Could you please get me access to "The Jet Database Engine Programmers Guide" . I currently do not have this guide.

-Regards

Harpreet

|||

Here is a link to the book on Amazon:

http://www.amazon.com/Microsoft-Database-Programmers-Professional-Editions/dp/B00005TNX9

The registry is:

HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\Jet 4.0\MaxLocksPerFile

default is 9500

|||

Hi Joel

Thanks for the information.

Still I have one question: Is there some file (configuration file or so) from where this default value of 9500 is taken and set in to the registry.

-Regards

Harpreet

|||The registry value is created in setup or when registering msjet40.dll.|||

HI Joel,

Can we change this registry value during registering.We have _drivers.ini file which contains default values for arguments.I tried to set the custom value in that ini file, but during installation, registry value is again set to default value of 9500.

MaxLocksPerFile

Hi

I wrote a script in Installshield that changes the MaxLocksPerFile value in
Registry for Jet 3.x and Jet 4.0
While installing the application through Installshield, the custom value for
MaxLocksPerFile is being overwritten to 9500 in Registry for Jet
4.0(HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Jet 4.0) but not
for Jet 3.x(HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Jet 3.x).
The value is being overwritten to 9500 before the control reaches at the
script code.

I am wondering from where this 9500 value is being retrieved and set in
Registry.
Is there some file where these default values are mentioned.
If so then why 9500 value is not being set for Jet 3.x and is being set only
for Jet 4.0.

i am using MS Office 2002. Drivers for ODBC MS Access is above 4.0
and Installshield Version is 5.5.

Please help me to resolve this Issue.

-Regards
Harpreet

The default value for both Jet 3.5 and 4.0 is 9500.

If your installation script is causing Jet to be re-registered it will reset the values in the registry back to their defaults and over write yours.

The 9500 value was originally put in for Netware servers and typically you do not need to change it from its default pf 9500.

See page 611 of "The Jet Database Engine Programmers Guide" or futher searching of MSDN.

|||

Hi Joel,

Thanx for your reply.

Could you please let me know from where this default value of 9500 is retrieved and set the registry variable.

Could you please get me access to "The Jet Database Engine Programmers Guide" . I currently do not have this guide.

-Regards

Harpreet

|||

Here is a link to the book on Amazon:

http://www.amazon.com/Microsoft-Database-Programmers-Professional-Editions/dp/B00005TNX9

The registry is:

HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\Jet 4.0\MaxLocksPerFile

default is 9500

|||

Hi Joel

Thanks for the information.

Still I have one question: Is there some file (configuration file or so) from where this default value of 9500 is taken and set in to the registry.

-Regards

Harpreet

|||The registry value is created in setup or when registering msjet40.dll.|||

HI Joel,

Can we change this registry value during registering.We have _drivers.ini file which contains default values for arguments.I tried to set the custom value in that ini file, but during installation, registry value is again set to default value of 9500.

Maximum Numbers of Tables and colums to access in select statement

Hi

I want to get the
Maximum Numbers of Tables and colums to access in select query statement

Regards
AruneshCitations from SQL Books Online:columns: The maximum number of expressions that can be specified in the select list is 4096