How Do I Change The Status On My Database? Currently Is Is Assigned As &"Restricted User&"

Making Restricted User To See Only The Database That Is Owned By It.....!
How would I hide the sa account to be accessible under Logins for a restricted User in sql server 2005 and also other folders like Replication, Managment, etc need to be hidden too.

 
 
any idea,
 
thank,s
 

View Replies !   View Related

---

Problem In SQL Developing As Restricted User (member Of User Group)
Greetings,VWD EE and other Tools do not have problems working O.K. on my machine, when I am logged-on as restricted(limited) user, both environment and local web server are functioning, and it was MS effort to do it right.BUT the Problem is, when I try to connect to database->new DB connection(either through vwd or management studio etc). I get an Error - which should be written to event log (according to msg) but it isn't - that I can't connect. I am sure that it is because NO SQL SERVER2005EXPRESS instance is running, which I think is the only prerequisite to have it work (I do not need sqlbrowser service I am doint local development).SQL2005express service is configured on MANUAL start. I can start it as administrator through SQL config manager, but it is not convienient and what I want. I need to start it ONLY as a developer user, I do not want it to be running all-the-time for everyuser using computer. It was congigured as Network Service logon, I tried Local Service logon, and I even tried configuring it to logon as -my developer user- account, e.g. with limited user name and his password.In every case I can't start the service as member of users group and this developer. Then I added limited user to SQL2005EXPRESS group. Still NO help, won't start either.My question is, If I want to start developing ADO2.NET application and I need to have running SQL2005Express instance as a develper, how can I start it? I think I do not have some rights to masterDB or something. Do it allways need to be running when computer starts? Isn't there any other way, to start it JUST when I think I start developing?I know of user-mode of accessing SQL2005express DBs, but it also assumes that SQL2005Express service is already running, what I am trying to prevent. I do not want to have it running for everyone who uses computer, just for someone who neeeds it.Any help explaining me the right way HOW TO SETUP WORKING ENVIRONMENT when developing as limited user welcome, I read the the documentations and haven't found the answers.THANK YOU !

View Replies !   View Related

---

Help With Restricted User...
I have what i think is a permissions problem in Server2005 and I'm hoping i'm on the right track here but here goes...

I have some legacy VB6 which is connecting to a LOG database and looping through the tabledefs. For some reason the code bugs out and both the err & dbengine errors descriptions are 'Unexpected Error: 3000 - Reserved error (-7778); there is no message for this error.'---VERY HELPFULL.

I take a look in management studio and next to my LOG database, in parethesis, it says 'Restricted User'. I'm fairly new to 2005 and i haven't seen this before but i'm guessing this may be the issue since the same action is performed on the main database (which has no such suffix) and the code runs through just fine. Makes no difference whether i use a Windows log-in or SQL log-in, the suffix remains. I also checked the server roles and user mapping,...everything is good.

Anyone got a clue why that's there and how i can get rid?

Help would be really appriciated.

View Replies !   View Related

---

Restricted User Mode
Hi all,
What is the syntax to set database to restricted user mode using SQL query analyzer?

View Replies !   View Related

---

SQLexpress Service Won't Run - Restricted User
I am developing as restricted user, and I can't run SQL express instance. It is set as NETWORK service as default, so I thought I could run it as network service under my user credentials. It is set to MANUAL start. I 've set it to Local Service and I can't it run too.The question is, should I set it to run JUST under my user account or put my user to some SQL group ? Which would bring more security issues? And there should be some tool from MS to do it, we have Surface Area config tool which despite its name won't set many things one would like. This is fundamental thing imo - to ask which user should operate with the DB, even if masterDB is set in directory where restricted user can't write.Thank you.

View Replies !   View Related

---

Determine User Assigned Rights To Public Role
Hi:
 
When I restore DB from testing to production, we want to remove extra access rights granted to public group.  Is there a simple way to query to find out for which objects (table, view, sp, fn) that public group were granted select, delete, update insert, or execute rights?
 
My objective is to write a sp to remove all user assigned rights to public group (role),  but not to deny any rights. How to do it?  

 
Any suggestion will be appreciated.
 

View Replies !   View Related

---

Change In Database User Perms When Copying Database
How to maintain Database User Permissions when copying the Database from One SQL Server to another(Either through backups or sp_detach). The reason is the login sid is different in the target server and as a result the database user is not able to map to the login existing in the target server. The only way I can correct this is through dropping and recreating the user's again and assign the permissions, or change the system catalog - sysusers to remap the login to the user in the database.
I do not wish to use the sp_addalias as it is available only for backward compatibility.
Is there a better way of doing this ?

View Replies !   View Related

---

Change Logins For Multiple Database User Groups
I have a SQL 2000 box with number of NT4 domain group logins. These groups are aliased to users in a particular database. I am now trying to map these users to new groups in an Active Directory domain. Is there an easy way to map the users to the new groups without deleting and recreating. I know this is possible with users but not sure with groups.

Thanks,
Michael

View Replies !   View Related

---

DBO Status Change From 6.5 To 7.0
Has anyone had problems with the DBO status when upgrading from 6.5 to 7.0 on MS SQL Server?

Under 7.0 the only way to make a person DBO is to make them a member of sysadmin group. Being a member of the sysadmin group allow them full access to all features of the server. For developers, this is a little too much. Other than that, the only other option is to make them db_owner which is not the same as DBO. Db_owner will allow full access to the database but the owner has to prefix the object calls by their login ID. In version 6.5, you could make a user DBO and they could use the DBO prefix on all object calls or none at all. This made it easy for multiple developers to access and work on the same database without adding additional overhead due to different Log-in ID being used.

Does anyone know of a way around this?

View Replies !   View Related

---

Accessing Windows Users Assigned To A Database Role
Is
there a way to find a list of Windows User accounts that are directly
or indirectly (through Windows Group membership) assigned to a database
role?


I could put work in to CLR programming or using a Linked Server to
Active Directory, but if there is a sys.* view available that can
provide me this
information directly it would be much easier.



I'll be looking into this further myself anyway and posting an answer
if I can find one, but if anyone has suggestions... well, thanks!

View Replies !   View Related

---

Why &"Restricted User&"?
I am download backup of SQL database from server and I am restore database successful into my SQL Server Management Studio Express, but near name of database stay: (Restricted User) note!When I try use database offline for login into my control panel created by me it not work. After I create small new database with same tables login work! I am admin on my local PC. Any ideas why my restored database has note: "Restricted User"? This is bigger database and looks complicate transfer data from old to new database, but if someone have these examples it can help too

View Replies !   View Related

---

How Can I Change The Step Status To &"failed&"
Hi friends,
please help me with my urgent needs.
I have created a job. This job contains 6 steps.
All steps are sql querries.
In step no:3 i have an if condition in the script.
When the condition becomes true i have to run the script.
That is ok.
But the problem is when the condition becomes falls i have
to go to the step no 6 and at the same time the status
of step no:3 should be like "failed".
can you help me please
Please this is an urgent reqirement.

Thank you.

View Replies !   View Related

---

Database Schemas And &&"This Statement Has Attempted To Access Data Whose Access Is Restricted By The Assembly.&&"
Hello.

View Replies !   View Related

---

How Do We Determine Which User Database Tables Are Mostly Retrieved By User Or Modified By User?
 

Hi,
     Please give the T-SQL  script for this ? Thanks
 
Shanth
 
  
 

View Replies !   View Related

---

CHANGE OF USER NAME
Hi Friends,

I want to change my USER NAME of the USER.

CHANGE THE OWNER SHIP Of the user 'shiv' - 'kumar'

what is command of that one OR GUI how can i change plz explain me

Meti BEST OF THE BEST

View Replies !   View Related

---

Getting SQL Or Database Status On Webpage.
Hi is it possible to have a page of a website display the status of a database or MS SQL with .Net code ?, if so what code would i use. Any help would be appreciated.Thank You 

View Replies !   View Related

---

How To See The Status Of All Triggers In A Database
I used the sp_msforeachtable stored proc to disable all triggers in a database. Once the command is complete, I want to see the statuses of all
these triggers . I am used to an Oracle database so I miss the data dictionary views that easily show this info. Also, I need to view the statuses of all FKs once they are all disabled as well.

View Replies !   View Related

---

Database In Loading Status


View Replies !   View Related

---

Database In Loading Status


View Replies !   View Related

---

Suspect Database Status
Hello,

A hard drive crashed on one of our MS SQL Server 2005 and brought the server down
with it. We had replaced the hard drive and rebuilt the RAID 5 container and got the server rebooted.
However, one of the databases got corrupted after that. THis is the error logs snippet:
===============
,An error occurred during recovery<c/> preventing the database 'survey_p0765392' (database ID 439) from restarting. Diagnose the recovery errors and fix them<c/> or restore from a known good backup. If errors are not corrected or expected<c/> contact Technical Support.,
===============
 
We have backup which is 2 days old, and restoring from the backup would result in us losing a lot of records that we
have created since then. Is there any way to recover the data from this database? How canI repair it? Please advice. Thanks

View Replies !   View Related

---

Change The Active User In Sp
Hello,
I would like to change the active user in a stored procedure
Ex. :
I'm logged on sql as "userA".
I call the stored procedure "spGetInfo".
In the first line of "spGetInfo" I would like to do something like "su poweruser", query some data and do "su system_user"

Is there anything like the unix "su" command in SQL ?

Thank a lot

Felix Pageau
fpageau@SPAMSUCK.str.ca

View Replies !   View Related

---

How To Change The User Name And Password
Hello

I newly installed SQL Server 2005 .I did not mention any username and password during installation.But now i want to specify one.Can you tell me how to do so .My Operating System is WindowsXp.

Thanks In Advance
Poornima

View Replies !   View Related

---

An Error Occurred In The Service Broker Internal Activator While Trying To Scan The User Queue '(null)' For Its Status. Error: 2
Hello - can't find any info on this error - can anyone shed some light?

 

There was a deadlock - which preceeded this message by 2 seconds.

 

 

 

04/25/2007 08:20:12,spid108,Unknown,An error occurred in the Service Broker internal activator while trying to scan the user queue '(null)' for its status. Error: 2905<c/> State: 1.
04/25/2007 08:20:12,spid108,Unknown,External dump process return code 0x20000001.<nl/>External dump process returned no errors.
04/25/2007 08:20:12,spid108,Unknown,Stack Signature for the dump is 0x1229B5AA
04/25/2007 08:20:12,spid108,Unknown,78132A36 Module(MSVCR80+00002A36)
04/25/2007 08:20:12,spid108,Unknown,781329AA Module(MSVCR80+000029AA)
04/25/2007 08:20:12,spid108,Unknown,01447720 Module(sqlservr+00447720)
04/25/2007 08:20:12,spid108,Unknown,0144789A Module(sqlservr+0044789A)
04/25/2007 08:20:12,spid108,Unknown,0144859B Module(sqlservr+0044859B)
04/25/2007 08:20:12,spid108,Unknown,01447562 Module(sqlservr+00447562)
04/25/2007 08:20:12,spid108,Unknown,01006DAB Module(sqlservr+00006DAB)
04/25/2007 08:20:12,spid108,Unknown,01006BBC Module(sqlservr+00006BBC)
04/25/2007 08:20:12,spid108,Unknown,01006A96 Module(sqlservr+00006A96)
04/25/2007 08:20:12,spid108,Unknown,0112F65C Module(sqlservr+0012F65C)
04/25/2007 08:20:12,spid108,Unknown,0112F70F Module(sqlservr+0012F70F)
04/25/2007 08:20:12,spid108,Unknown,0112CB04 Module(sqlservr+0012CB04)
04/25/2007 08:20:12,spid108,Unknown,0112D1D1 Module(sqlservr+0012D1D1)
04/25/2007 08:20:12,spid108,Unknown,0112EA61 Module(sqlservr+0012EA61)
04/25/2007 08:20:12,spid108,Unknown,0108A5CB Module(sqlservr+0008A5CB)
04/25/2007 08:20:12,spid108,Unknown,0108A56B Module(sqlservr+0008A56B)
04/25/2007 08:20:12,spid108,Unknown,01060A5A Module(sqlservr+00060A5A)
04/25/2007 08:20:12,spid108,Unknown,01476CB2 Module(sqlservr+00476CB2)
04/25/2007 08:20:12,spid108,Unknown,01476FD3 Module(sqlservr+00476FD3)
04/25/2007 08:20:12,spid108,Unknown,017FA720 Module(sqlservr+007FA720)
04/25/2007 08:20:12,spid108,Unknown,017FAADC Module(sqlservr+007FAADC)
04/25/2007 08:20:12,spid108,Unknown,01796B1B Module(sqlservr+00796B1B)
04/25/2007 08:20:12,spid108,Unknown,01793310 Module(sqlservr+00793310)
04/25/2007 08:20:12,spid108,Unknown,0179438B Module(sqlservr+0079438B)
04/25/2007 08:20:12,spid108,Unknown,* Short Stack Dump
04/25/2007 08:20:12,spid108,Unknown,* -------------------------------------------------------------------------------
04/25/2007 08:20:12,spid108,Unknown,* *******************************************************************************
04/25/2007 08:20:12,spid108,Unknown,*      SegSs: 00000023:
04/25/2007 08:20:12,spid108,Unknown,*        Esp: 1302E584:  13025387  80C87378  80C872F0  00000000  78140001  0009D9C2
04/25/2007 08:20:12,spid108,Unknown,*     EFlags: 00010202:  00610067  00650074  0049003B  0076006E  006C0061  00640069
04/25/2007 08:20:12,spid108,Unknown,*      SegCs: 0000001B:
04/25/2007 08:20:12,spid108,Unknown,*        Ebp: 1302F67C:  1302F788  01793310  13025373  80C872F0  7093AB12  801E8B38
04/25/2007 08:20:12,spid108,Unknown,*        Eip: 0179438B:  828B118B  000000E0  C085D0FF  00B9850F  9D890000  FFFFEF8C
04/25/2007 08:20:12,spid108,Unknown,*        Edx: 00000E38:
04/25/2007 08:20:12,spid108,Unknown,*        Ecx: 00000000:
04/25/2007 08:20:12,spid108,Unknown,*        Ebx: 00000000:
04/25/2007 08:20:12,spid108,Unknown,*        Eax: A99EE598:  00000000  00000000  A99EE5B0  00000000  00000000  00000000
04/25/2007 08:20:12,spid108,Unknown,*        Esi: 00000000:
04/25/2007 08:20:12,spid108,Unknown,*        Edi: 80C872F0:  7093AB12  80C87FF0  00000007  B8A20008  7093AB15  00000000
04/25/2007 08:20:12,spid108,Unknown,*
04/25/2007 08:20:12,spid108,Unknown,* dbghelp                        14200000  14312FFF  00113000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70                       76780000  76913FFF  00194000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70                       764A0000  76633FFF  00194000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70                       76300000  76493FFF  00194000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70                       341D0000  343AFFFF  001e0000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70                       33590000  33764FFF  001d5000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70                       333F0000  33583FFF  00194000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70                       14490000  1467AFFF  001eb000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70                       13D10000  13EFBFFF  001ec000
04/25/2007 08:20:12,spid108,Unknown,* OLEDB32R                       13770000  13780FFF  00011000
04/25/2007 08:20:12,spid108,Unknown,* MSDART                         133D0000  133E9FFF  0001a000
04/25/2007 08:20:12,spid108,Unknown,* oledb32                        13350000  133C8FFF  00079000
04/25/2007 08:20:12,spid108,Unknown,* msxml3                         11BD0000  11CE1FFF  00112000
04/25/2007 08:20:12,spid108,Unknown,* msxmlsql                       11AF0000  11BC5FFF  000d6000
04/25/2007 08:20:12,spid108,Unknown,* System.Xml                     10FA0000  11193FFF  001f4000
04/25/2007 08:20:12,spid108,Unknown,* System.Security                10F20000  10F61FFF  00042000
04/25/2007 08:20:12,spid108,Unknown,* System                         10C10000  10EF3FFF  002e4000
04/25/2007 08:20:12,spid108,Unknown,* System.Security.ni             10A90000  10B45FFF  000b6000
04/25/2007 08:20:12,spid108,Unknown,* System.Transactions            0FAD0000  0FB12FFF  00043000
04/25/2007 08:20:12,spid108,Unknown,* System.ni                      7A440000  7ABFDFFF  007be000
04/25/2007 08:20:12,spid108,Unknown,* System.Data                    102D0000  10596FFF  002c7000
04/25/2007 08:20:12,spid108,Unknown,* mscorjit                       0F910000  0F962FFF  00053000
04/25/2007 08:20:12,spid108,Unknown,* SqlAccess                      0F8A0000  0F8F5FFF  00056000
04/25/2007 08:20:12,spid108,Unknown,* SensApi                        0F880000  0F884FFF  00005000
04/25/2007 08:20:12,spid108,Unknown,* cryptnet                       0F680000  0F691FFF  00012000
04/25/2007 08:20:12,spid108,Unknown,* SOFTPUB                        0F670000  0F674FFF  00005000
04/25/2007 08:20:12,spid108,Unknown,* mscorsec                       0F640000  0F652FFF  00013000
04/25/2007 08:20:12,spid108,Unknown,* mscorlib.ni                    0EAC0000  0F5A7FFF  00ae8000
04/25/2007 08:20:12,spid108,Unknown,* mscorwks                       080E0000  08640FFF  00561000
04/25/2007 08:20:12,spid108,Unknown,* xplog70                        07CA0000  07CA2FFF  00003000
04/25/2007 08:20:12,spid108,Unknown,* xplog70                        07C80000  07C8BFFF  0000c000
04/25/2007 08:20:12,spid108,Unknown,* xpstar90                       07C50000  07C75FFF  00026000
04/25/2007 08:20:12,spid108,Unknown,* odbcint                        07C30000  07C46FFF  00017000
04/25/2007 08:20:12,spid108,Unknown,* ATL80                          7C630000  7C64AFFF  0001b000
04/25/2007 08:20:12,spid108,Unknown,* BatchParser90                  07A40000  07A5EFFF  0001f000
04/25/2007 08:20:12,spid108,Unknown,* ODBC32                         07A00000  07A3CFFF  0003d000
04/25/2007 08:20:12,spid108,Unknown,* SQLSCM90                       079E0000  079E8FFF  00009000
04/25/2007 08:20:12,spid108,Unknown,* xpstar90                       07980000  079C7FFF  00048000
04/25/2007 08:20:12,spid108,Unknown,* xpsqlbot                       07960000  07965FFF  00006000
04/25/2007 08:20:12,spid108,Unknown,* msftepxy                       07490000  074A4FFF  00015000
04/25/2007 08:20:12,spid108,Unknown,* SQLNCLIR                       007A0000  007D2FFF  00033000
04/25/2007 08:20:12,spid108,Unknown,* comdlg32                       762B0000  762F9FFF  0004a000
04/25/2007 08:20:12,spid108,Unknown,* COMCTL32                       77530000  775C6FFF  00097000
04/25/2007 08:20:12,spid108,Unknown,* sqlncli                        337A0000  339C1FFF  00222000
04/25/2007 08:20:12,spid108,Unknown,* CLBCatQ                        777B0000  77832FFF  00083000
04/25/2007 08:20:12,spid108,Unknown,* xpsp2res                       10000000  102C4FFF  002c5000
04/25/2007 08:20:12,spid108,Unknown,* ntdsapi                        766F0000  76704FFF  00015000
04/25/2007 08:20:12,spid108,Unknown,* wshtcpip                       070B0000  070B7FFF  00008000
04/25/2007 08:20:12,spid108,Unknown,* hnetcfg                        071F0000  07248FFF  00059000
04/25/2007 08:20:12,spid108,Unknown,* dssenh                         070C0000  070E3FFF  00024000
04/25/2007 08:20:12,spid108,Unknown,* imagehlp                       76C10000  76C38FFF  00029000
04/25/2007 08:20:12,spid108,Unknown,* WINTRUST                       76BB0000  76BDAFFF  0002b000
04/25/2007 08:20:12,spid108,Unknown,* dbghelp                        06C10000  06D22FFF  00113000
04/25/2007 08:20:12,spid108,Unknown,* msfte                          069B0000  06C08FFF  00259000
04/25/2007 08:20:12,spid108,Unknown,* security                       06190000  06193FFF  00004000
04/25/2007 08:20:12,spid108,Unknown,* rasadhlp                       76F80000  76F84FFF  00005000
04/25/2007 08:20:12,spid108,Unknown,* winrnr                         76F70000  76F76FFF  00007000
04/25/2007 08:20:12,spid108,Unknown,* DNSAPI                         76ED0000  76EF8FFF  00029000
04/25/2007 08:20:12,spid108,Unknown,* RESUTILS                       05D50000  05D62FFF  00013000
04/25/2007 08:20:12,spid108,Unknown,* CLUSAPI                        05D30000  05D41FFF  00012000
04/25/2007 08:20:12,spid108,Unknown,* OLEAUT32                       77D00000  77D8BFFF  0008c000
04/25/2007 08:20:12,spid108,Unknown,* WSOCK32                        71BB0000  71BB8FFF  00009000
04/25/2007 08:20:12,spid108,Unknown,* VERSION                        77B90000  77B97FFF  00008000
04/25/2007 08:20:12,spid108,Unknown,* MTXCLU                         05D10000  05D28FFF  00019000
04/25/2007 08:20:12,spid108,Unknown,* msvcp60                        780C0000  78120FFF  00061000
04/25/2007 08:20:12,spid108,Unknown,* MSDTCPRX                       05C90000  05D07FFF  00078000
04/25/2007 08:20:12,spid108,Unknown,* XOLEHLP                        05C80000  05C85FFF  00006000
04/25/2007 08:20:12,spid108,Unknown,* COMRES                         77010000  770D5FFF  000c6000
04/25/2007 08:20:12,spid108,Unknown,* schannel                       76750000  76776FFF  00027000
04/25/2007 08:20:12,spid108,Unknown,* cryptdll                       766E0000  766EBFFF  0000c000
04/25/2007 08:20:12,spid108,Unknown,* kerberos                       05BC0000  05C17FFF  00058000
04/25/2007 08:20:12,spid108,Unknown,* iphlpapi                       76CF0000  76D09FFF  0001a000
04/25/2007 08:20:12,spid108,Unknown,* msv1_0                         76C90000  76CB6FFF  00027000
04/25/2007 08:20:12,spid108,Unknown,* MSCOREE                        05950000  05994FFF  00045000
04/25/2007 08:20:12,spid108,Unknown,* AUTHZ                          76C40000  76C53FFF  00014000
04/25/2007 08:20:12,spid108,Unknown,* rsaenh                         04E90000  04EBEFFF  0002f000
04/25/2007 08:20:12,spid108,Unknown,* WLDAP32                        76F10000  76F3DFFF  0002e000
04/25/2007 08:20:12,spid108,Unknown,* SAMLIB                         5CCF0000  5CCFEFFF  0000f000
04/25/2007 08:20:12,spid108,Unknown,* ole32                          77670000  777A3FFF  00134000
04/25/2007 08:20:12,spid108,Unknown,* NTMARTA                        77E00000  77E21FFF  00022000
04/25/2007 08:20:12,spid108,Unknown,* SQLOS                          344D0000  344D4FFF  00005000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70                       4F610000  4F7A3FFF  00194000
04/25/2007 08:20:12,spid108,Unknown,* instapi                        48060000  48069FFF  0000a000
04/25/2007 08:20:12,spid108,Unknown,* psapi                          76B70000  76B7AFFF  0000b000
04/25/2007 08:20:12,spid108,Unknown,* comctl32                       77420000  77522FFF  00103000
04/25/2007 08:20:12,spid108,Unknown,* SHLWAPI                        77DA0000  77DF1FFF  00052000
04/25/2007 08:20:12,spid108,Unknown,* SHELL32                        7C8D0000  7D0D2FFF  00803000
04/25/2007 08:20:12,spid108,Unknown,* NETAPI32                       71C40000  71C97FFF  00058000
04/25/2007 08:20:12,spid108,Unknown,* opends60                       333E0000  333E6FFF  00007000
04/25/2007 08:20:12,spid108,Unknown,* USERENV                        76920000  769E3FFF  000c4000
04/25/2007 08:20:12,spid108,Unknown,* WS2HELP                        71BF0000  71BF7FFF  00008000
04/25/2007 08:20:12,spid108,Unknown,* WS2_32                         71C00000  71C16FFF  00017000
04/25/2007 08:20:12,spid108,Unknown,* MSWSOCK                        71B20000  71B60FFF  00041000
04/25/2007 08:20:12,spid108,Unknown,* Secur32                        76F50000  76F62FFF  00013000
04/25/2007 08:20:12,spid108,Unknown,* MSASN1                         76190000  761A1FFF  00012000
04/25/2007 08:20:12,spid108,Unknown,* CRYPT32                        761B0000  76242FFF  00093000
04/25/2007 08:20:12,spid108,Unknown,* GDI32                          77C00000  77C47FFF  00048000
04/25/2007 08:20:12,spid108,Unknown,* USER32                         77380000  77411FFF  00092000
04/25/2007 08:20:12,spid108,Unknown,* RPCRT4                         77C50000  77CEEFFF  0009f000
04/25/2007 08:20:12,spid108,Unknown,* ADVAPI32                       77F50000  77FEBFFF  0009c000
04/25/2007 08:20:12,spid108,Unknown,* MSVCP80                        7C420000  7C4A6FFF  00087000
04/25/2007 08:20:12,spid108,Unknown,* msvcrt                         77BA0000  77BF9FFF  0005a000
04/25/2007 08:20:12,spid108,Unknown,* MSVCR80                        78130000  781CAFFF  0009b000
04/25/2007 08:20:12,spid108,Unknown,* kernel32                       77E40000  77F41FFF  00102000
04/25/2007 08:20:12,spid108,Unknown,* ntdll                          7C800000  7C8BFFFF  000c0000
04/25/2007 08:20:12,spid108,Unknown,* sqlservr                       01000000  02BCEFFF  01bcf000
04/25/2007 08:20:12,spid108,Unknown,*  MODULE                          BASE      END       SIZE
04/25/2007 08:20:12,spid108,Unknown,*
04/25/2007 08:20:12,spid108,Unknown,*
04/25/2007 08:20:12,spid108,Unknown,*   Access Violation occurred reading address 00000000
04/25/2007 08:20:12,spid108,Unknown,*   Exception Code    = c0000005 EXCEPTION_ACCESS_VIOLATION
04/25/2007 08:20:12,spid108,Unknown,*   Exception Address = 0179438B Module(sqlservr+0079438B)
04/25/2007 08:20:12,spid108,Unknown,*
04/25/2007 08:20:12,spid108,Unknown,*
04/25/2007 08:20:12,spid108,Unknown,*   04/25/07 08:20:12 spid 108
04/25/2007 08:20:12,spid108,Unknown,* BEGIN STACK DUMP:
04/25/2007 08:20:12,spid108,Unknown,*
04/25/2007 08:20:12,spid108,Unknown,* *******************************************************************************
04/25/2007 08:20:12,spid108,Unknown,SqlDumpExceptionHandler: Process 108 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
04/25/2007 08:20:12,spid108,Unknown,***Stack Dump being sent to D:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGSQLDump0007.txt
04/25/2007 08:20:12,spid108,Unknown,Using 'dbghelp.dll' version '4.0.5'
04/25/2007 08:20:12,spid60,Unknown,An error occurred in the Service Broker internal activator while trying to scan the user queue '(null)' for its status. Error: 2905<c/> State: 1.
04/25/2007 08:20:12,spid60,Unknown,External dump process return code 0x20000001.<nl/>External dump process returned no errors.
04/25/2007 08:20:10,spid60,Unknown,Stack Signature for the dump is 0x1229B5AA
04/25/2007 08:20:10,spid60,Unknown,78132A36 Module(MSVCR80+00002A36)
04/25/2007 08:20:10,spid60,Unknown,781329AA Module(MSVCR80+000029AA)
04/25/2007 08:20:10,spid60,Unknown,01447720 Module(sqlservr+00447720)
04/25/2007 08:20:10,spid60,Unknown,0144789A Module(sqlservr+0044789A)
04/25/2007 08:20:10,spid60,Unknown,0144859B Module(sqlservr+0044859B)
04/25/2007 08:20:10,spid60,Unknown,01447562 Module(sqlservr+00447562)
04/25/2007 08:20:10,spid60,Unknown,01006DAB Module(sqlservr+00006DAB)
04/25/2007 08:20:10,spid60,Unknown,01006BBC Module(sqlservr+00006BBC)
04/25/2007 08:20:10,spid60,Unknown,01006A96 Module(sqlservr+00006A96)
04/25/2007 08:20:10,spid60,Unknown,0112F65C Module(sqlservr+0012F65C)
04/25/2007 08:20:10,spid60,Unknown,0112F70F Module(sqlservr+0012F70F)
04/25/2007 08:20:10,spid60,Unknown,0112CB04 Module(sqlservr+0012CB04)
04/25/2007 08:20:10,spid60,Unknown,0112D1D1 Module(sqlservr+0012D1D1)
04/25/2007 08:20:10,spid60,Unknown,0112EA61 Module(sqlservr+0012EA61)
04/25/2007 08:20:10,spid60,Unknown,0108A5CB Module(sqlservr+0008A5CB)
04/25/2007 08:20:10,spid60,Unknown,0108A56B Module(sqlservr+0008A56B)
04/25/2007 08:20:10,spid60,Unknown,01060A5A Module(sqlservr+00060A5A)
04/25/2007 08:20:10,spid60,Unknown,01476CB2 Module(sqlservr+00476CB2)
04/25/2007 08:20:10,spid60,Unknown,01476FD3 Module(sqlservr+00476FD3)
04/25/2007 08:20:10,spid60,Unknown,017FA720 Module(sqlservr+007FA720)
04/25/2007 08:20:10,spid60,Unknown,017FAADC Module(sqlservr+007FAADC)
04/25/2007 08:20:10,spid60,Unknown,01796B1B Module(sqlservr+00796B1B)
04/25/2007 08:20:10,spid60,Unknown,01793310 Module(sqlservr+00793310)
04/25/2007 08:20:10,spid60,Unknown,0179438B Module(sqlservr+0079438B)
04/25/2007 08:20:10,spid60,Unknown,* Short Stack Dump
04/25/2007 08:20:10,spid60,Unknown,* -------------------------------------------------------------------------------
04/25/2007 08:20:10,spid60,Unknown,* *******************************************************************************
04/25/2007 08:20:10,spid60,Unknown,*      SegSs: 00000023:
04/25/2007 08:20:10,spid60,Unknown,*        Esp: 1189E584:  11895387  80C87378  80C872F0  00000000  03E90001  00087C2D
04/25/2007 08:20:10,spid60,Unknown,*     EFlags: 00010202:  00610067  00650074  0049003B  0076006E  006C0061  00640069
04/25/2007 08:20:10,spid60,Unknown,*      SegCs: 0000001B:
04/25/2007 08:20:10,spid60,Unknown,*        Ebp: 1189F67C:  1189F788  01793310  11895373  80C872F0  7093AB12  801E8B38
04/25/2007 08:20:10,spid60,Unknown,*        Eip: 0179438B:  828B118B  000000E0  C085D0FF  00B9850F  9D890000  FFFFEF8C
04/25/2007 08:20:10,spid60,Unknown,*        Edx: 00000E38:
04/25/2007 08:20:10,spid60,Unknown,*        Ecx: 00000000:
04/25/2007 08:20:10,spid60,Unknown,*        Ebx: 00000000:
04/25/2007 08:20:10,spid60,Unknown,*        Eax: 5ADE8598:  00000000  00000000  5ADE85B0  00000000  00000000  00000000
04/25/2007 08:20:10,spid60,Unknown,*        Esi: 00000000:
04/25/2007 08:20:10,spid60,Unknown,*        Edi: 80C872F0:  7093AB12  80C87FF0  00000007  B8A20008  7093AB15  00000000
04/25/2007 08:20:10,spid60,Unknown,*
04/25/2007 08:20:10,spid60,Unknown,* dbghelp                        14200000  14312FFF  00113000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70                       76780000  76913FFF  00194000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70                       764A0000  76633FFF  00194000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70                       76300000  76493FFF  00194000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70                       341D0000  343AFFFF  001e0000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70                       33590000  33764FFF  001d5000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70                       333F0000  33583FFF  00194000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70                       14490000  1467AFFF  001eb000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70                       13D10000  13EFBFFF  001ec000
04/25/2007 08:20:10,spid60,Unknown,* OLEDB32R                       13770000  13780FFF  00011000
04/25/2007 08:20:10,spid60,Unknown,* MSDART                         133D0000  133E9FFF  0001a000
04/25/2007 08:20:10,spid60,Unknown,* oledb32                        13350000  133C8FFF  00079000
04/25/2007 08:20:10,spid60,Unknown,* msxml3                         11BD0000  11CE1FFF  00112000
04/25/2007 08:20:10,spid60,Unknown,* msxmlsql                       11AF0000  11BC5FFF  000d6000
04/25/2007 08:20:10,spid60,Unknown,* System.Xml                     10FA0000  11193FFF  001f4000
04/25/2007 08:20:10,spid60,Unknown,* System.Security                10F20000  10F61FFF  00042000
04/25/2007 08:20:10,spid60,Unknown,* System                         10C10000  10EF3FFF  002e4000
04/25/2007 08:20:10,spid60,Unknown,* System.Security.ni             10A90000  10B45FFF  000b6000
04/25/2007 08:20:10,spid60,Unknown,* System.Transactions            0FAD0000  0FB12FFF  00043000
04/25/2007 08:20:10,spid60,Unknown,* System.ni                      7A440000  7ABFDFFF  007be000
04/25/2007 08:20:10,spid60,Unknown,* System.Data                    102D0000  10596FFF  002c7000
04/25/2007 08:20:10,spid60,Unknown,* mscorjit                       0F910000  0F962FFF  00053000
04/25/2007 08:20:10,spid60,Unknown,* SqlAccess                      0F8A0000  0F8F5FFF  00056000
04/25/2007 08:20:10,spid60,Unknown,* SensApi                        0F880000  0F884FFF  00005000
04/25/2007 08:20:10,spid60,Unknown,* cryptnet                       0F680000  0F691FFF  00012000
04/25/2007 08:20:10,spid60,Unknown,* SOFTPUB                        0F670000  0F674FFF  00005000
04/25/2007 08:20:10,spid60,Unknown,* mscorsec                       0F640000  0F652FFF  00013000
04/25/2007 08:20:10,spid60,Unknown,* mscorlib.ni                    0EAC0000  0F5A7FFF  00ae8000
04/25/2007 08:20:10,spid60,Unknown,* mscorwks                       080E0000  08640FFF  00561000
04/25/2007 08:20:10,spid60,Unknown,* xplog70                        07CA0000  07CA2FFF  00003000
04/25/2007 08:20:10,spid60,Unknown,* xplog70                        07C80000  07C8BFFF  0000c000
04/25/2007 08:20:10,spid60,Unknown,* xpstar90                       07C50000  07C75FFF  00026000
04/25/2007 08:20:10,spid60,Unknown,* odbcint                        07C30000  07C46FFF  00017000
04/25/2007 08:20:10,spid60,Unknown,* ATL80                          7C630000  7C64AFFF  0001b000
04/25/2007 08:20:10,spid60,Unknown,* BatchParser90                  07A40000  07A5EFFF  0001f000
04/25/2007 08:20:10,spid60,Unknown,* ODBC32                         07A00000  07A3CFFF  0003d000
04/25/2007 08:20:10,spid60,Unknown,* SQLSCM90                       079E0000  079E8FFF  00009000
04/25/2007 08:20:10,spid60,Unknown,* xpstar90                       07980000  079C7FFF  00048000
04/25/2007 08:20:10,spid60,Unknown,* xpsqlbot                       07960000  07965FFF  00006000
04/25/2007 08:20:10,spid60,Unknown,* msftepxy                       07490000  074A4FFF  00015000
04/25/2007 08:20:10,spid60,Unknown,* SQLNCLIR                       007A0000  007D2FFF  00033000
04/25/2007 08:20:10,spid60,Unknown,* comdlg32                       762B0000  762F9FFF  0004a000
04/25/2007 08:20:10,spid60,Unknown,* COMCTL32                       77530000  775C6FFF  00097000
04/25/2007 08:20:10,spid60,Unknown,* sqlncli                        337A0000  339C1FFF  00222000
04/25/2007 08:20:10,spid60,Unknown,* CLBCatQ                        777B0000  77832FFF  00083000
04/25/2007 08:20:10,spid60,Unknown,* xpsp2res                       10000000  102C4FFF  002c5000
04/25/2007 08:20:10,spid60,Unknown,* ntdsapi                        766F0000  76704FFF  00015000
04/25/2007 08:20:10,spid60,Unknown,* wshtcpip                       070B0000  070B7FFF  00008000
04/25/2007 08:20:10,spid60,Unknown,* hnetcfg                        071F0000  07248FFF  00059000
04/25/2007 08:20:10,spid60,Unknown,* dssenh                         070C0000  070E3FFF  00024000
04/25/2007 08:20:10,spid60,Unknown,* imagehlp                       76C10000  76C38FFF  00029000
04/25/2007 08:20:10,spid60,Unknown,* WINTRUST                       76BB0000  76BDAFFF  0002b000
04/25/2007 08:20:10,spid60,Unknown,* dbghelp                        06C10000  06D22FFF  00113000
04/25/2007 08:20:10,spid60,Unknown,* msfte                          069B0000  06C08FFF  00259000
04/25/2007 08:20:10,spid60,Unknown,* security                       06190000  06193FFF  00004000
04/25/2007 08:20:10,spid60,Unknown,* rasadhlp                       76F80000  76F84FFF  00005000
04/25/2007 08:20:10,spid60,Unknown,* winrnr                         76F70000  76F76FFF  00007000
04/25/2007 08:20:10,spid60,Unknown,* DNSAPI                         76ED0000  76EF8FFF  00029000
04/25/2007 08:20:10,spid60,Unknown,* RESUTILS                       05D50000  05D62FFF  00013000
04/25/2007 08:20:10,spid60,Unknown,* CLUSAPI                        05D30000  05D41FFF  00012000
04/25/2007 08:20:10,spid60,Unknown,* OLEAUT32                       77D00000  77D8BFFF  0008c000
04/25/2007 08:20:10,spid60,Unknown,* WSOCK32                        71BB0000  71BB8FFF  00009000
04/25/2007 08:20:10,spid60,Unknown,* VERSION                        77B90000  77B97FFF  00008000
04/25/2007 08:20:10,spid60,Unknown,* MTXCLU                         05D10000  05D28FFF  00019000
04/25/2007 08:20:10,spid60,Unknown,* msvcp60                        780C0000  78120FFF  00061000
04/25/2007 08:20:10,spid60,Unknown,* MSDTCPRX                       05C90000  05D07FFF  00078000
04/25/2007 08:20:10,spid60,Unknown,* XOLEHLP                        05C80000  05C85FFF  00006000
04/25/2007 08:20:10,spid60,Unknown,* COMRES                         77010000  770D5FFF  000c6000
04/25/2007 08:20:10,spid60,Unknown,* schannel                       76750000  76776FFF  00027000
04/25/2007 08:20:10,spid60,Unknown,* cryptdll                       766E0000  766EBFFF  0000c000
04/25/2007 08:20:10,spid60,Unknown,* kerberos                       05BC0000  05C17FFF  00058000
04/25/2007 08:20:10,spid60,Unknown,* iphlpapi                       76CF0000  76D09FFF  0001a000
04/25/2007 08:20:10,spid60,Unknown,* msv1_0                         76C90000  76CB6FFF  00027000
04/25/2007 08:20:10,spid60,Unknown,* MSCOREE                        05950000  05994FFF  00045000
04/25/2007 08:20:10,spid60,Unknown,* AUTHZ                          76C40000  76C53FFF  00014000
04/25/2007 08:20:10,spid60,Unknown,* rsaenh                         04E90000  04EBEFFF  0002f000
04/25/2007 08:20:10,spid60,Unknown,* WLDAP32                        76F10000  76F3DFFF  0002e000
04/25/2007 08:20:10,spid60,Unknown,* SAMLIB                         5CCF0000  5CCFEFFF  0000f000
04/25/2007 08:20:10,spid60,Unknown,* ole32                          77670000  777A3FFF  00134000
04/25/2007 08:20:10,spid60,Unknown,* NTMARTA                        77E00000  77E21FFF  00022000
04/25/2007 08:20:10,spid60,Unknown,* SQLOS                          344D0000  344D4FFF  00005000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70                       4F610000  4F7A3FFF  00194000
04/25/2007 08:20:10,spid60,Unknown,* instapi                        48060000  48069FFF  0000a000
04/25/2007 08:20:10,spid60,Unknown,* psapi                          76B70000  76B7AFFF  0000b000
04/25/2007 08:20:10,spid60,Unknown,* comctl32                       77420000  77522FFF  00103000
04/25/2007 08:20:10,spid60,Unknown,* SHLWAPI                        77DA0000  77DF1FFF  00052000
04/25/2007 08:20:10,spid60,Unknown,* SHELL32                        7C8D0000  7D0D2FFF  00803000
04/25/2007 08:20:10,spid60,Unknown,* NETAPI32                       71C40000  71C97FFF  00058000
04/25/2007 08:20:10,spid60,Unknown,* opends60                       333E0000  333E6FFF  00007000
04/25/2007 08:20:10,spid60,Unknown,* USERENV                        76920000  769E3FFF  000c4000
04/25/2007 08:20:10,spid60,Unknown,* WS2HELP                        71BF0000  71BF7FFF  00008000
04/25/2007 08:20:10,spid60,Unknown,* WS2_32                         71C00000  71C16FFF  00017000
04/25/2007 08:20:10,spid60,Unknown,* MSWSOCK                        71B20000  71B60FFF  00041000
04/25/2007 08:20:10,spid60,Unknown,* Secur32                        76F50000  76F62FFF  00013000
04/25/2007 08:20:10,spid60,Unknown,* MSASN1                         76190000  761A1FFF  00012000
04/25/2007 08:20:10,spid60,Unknown,* CRYPT32                        761B0000  76242FFF  00093000
04/25/2007 08:20:10,spid60,Unknown,* GDI32                          77C00000  77C47FFF  00048000
04/25/2007 08:20:10,spid60,Unknown,* USER32                         77380000  77411FFF  00092000
04/25/2007 08:20:10,spid60,Unknown,* RPCRT4                         77C50000  77CEEFFF  0009f000
04/25/2007 08:20:10,spid60,Unknown,* ADVAPI32                       77F50000  77FEBFFF  0009c000
04/25/2007 08:20:10,spid60,Unknown,* MSVCP80                        7C420000  7C4A6FFF  00087000
04/25/2007 08:20:10,spid60,Unknown,* msvcrt                         77BA0000  77BF9FFF  0005a000
04/25/2007 08:20:10,spid60,Unknown,* MSVCR80                        78130000  781CAFFF  0009b000
04/25/2007 08:20:10,spid60,Unknown,* kernel32                       77E40000  77F41FFF  00102000
04/25/2007 08:20:10,spid60,Unknown,* ntdll                          7C800000  7C8BFFFF  000c0000
04/25/2007 08:20:10,spid60,Unknown,* sqlservr                       01000000  02BCEFFF  01bcf000
04/25/2007 08:20:10,spid60,Unknown,*  MODULE                          BASE      END       SIZE
04/25/2007 08:20:10,spid60,Unknown,*
04/25/2007 08:20:10,spid60,Unknown,*
04/25/2007 08:20:10,spid60,Unknown,*   Access Violation occurred reading address 00000000
04/25/2007 08:20:10,spid60,Unknown,*   Exception Code    = c0000005 EXCEPTION_ACCESS_VIOLATION
04/25/2007 08:20:10,spid60,Unknown,*   Exception Address = 0179438B Module(sqlservr+0079438B)
04/25/2007 08:20:10,spid60,Unknown,*
04/25/2007 08:20:10,spid60,Unknown,*
04/25/2007 08:20:10,spid60,Unknown,*   04/25/07 08:20:10 spid 60
04/25/2007 08:20:10,spid60,Unknown,* BEGIN STACK DUMP:
04/25/2007 08:20:10,spid60,Unknown,*
04/25/2007 08:20:10,spid60,Unknown,* *******************************************************************************
04/25/2007 08:20:10,spid60,Unknown,SqlDumpExceptionHandler: Process 60 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
04/25/2007 08:20:10,spid60,Unknown,***Stack Dump being sent to D:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGSQLDump0006.txt
04/25/2007 08:20:10,spid60,Unknown,Using 'dbghelp.dll' version '4.0.5'

View Replies !   View Related

---

Database Design For Status Field
Hello,
I have a database design question. I want to store a status in a table. In the ASP.NET interface for the user this status will be adapted to the language of the user.
This is how it would look like:
StatusID 1 = "yes" for English, "oui" for French, "ja" for DutchStatusID 2 = "no" for English, "non" for French, "neen" for DutchStatusID 3 = "error" for English, "erreur" for French, "fout" for Dutch
I don't want to do the translation in ASP.NET and it should be done in one query.
How would it look like in the database design.

View Replies !   View Related

---

Timestamp Ans Status Of Database File
Our database is running in full recovery mode and we backup the logfile every hour and the database file every night. I notice thetimestamp of database file *.mdf remains unchanged a few days. Forexample one database has its timestamp at Apr 15 while it is Apr 20already.I am wondering if this is acceptable. How do I force the system toflush the data and dirty blocks to the disk more frequently? What isthe downside to this?Thanks for any idea.

View Replies !   View Related

---

Database Status Codes - Can Someone Post Them Here?
Hi:

I want to create a script to get the DB Status of my db's on my 6.5 servers. I know I will have to query the sysdatabase tables....Suspect is 256? any others? TIA

View Replies !   View Related

---

Visible Parameters That User Cannot Change
 I have a report that I want users to navigate to and I want them to see the parameters of the report, but I don't want them to be able to change them. Is this possible?

View Replies !   View Related

---

How To Change The User Account And Password
HI,

I m swagatika and working on a s/w company.I am facing some problem in MS SqlServer2005.

my problem is:-

i installed sql server2005 completely .At the install time , i set the username='xyz' and password=blank (windows authentication mode).

Now i want to change my user account to 'sa' and password to blank.

After installation,how to change the user account and password.

Please can anybody help me ?

View Replies !   View Related

---

Change The Number Of User Propertie
Hi,

I'm new in all this, I have sql server 2005 and have a problem I need let access to more users to the database, in the properties page of my DB I hava a Number of user field with 5, how can change this to up number?

I hope can help me.

View Replies !   View Related

---

Can't Change Sql Login User's Password
SQL Server 2005 Express will not allow me to change the password for my login user. I tried deleting the user and re-creating the user. Another password is being put in although the password I put in was accepted. I even test to see what would happen if I left the password blank. It got accepted. But when I look at the password for my login user again, a different and much longer password was put in. I even tried this T-SQL statement:

CREATE LOGIN <loginname> WITH PASSWORD='<passwordname>', CHECK_EXPIRATION = OFF, CHECK_POLICY = OFF

I am out of ideals. Is this a bug?

View Replies !   View Related

---

Restricted Login Creations
Hi,
I have a problem.While creating login for a single table in a database we know the public role is given by default.
I have use to disabled all public priviledges by-
Use northwind
revoke all from public
executing through query Analyser.
And after creating a role named "reception" and giving the priviledges of "select' to customer table by ticking and assigning that role to the login I get my login.
But using that login When I login,I can use select to see customer table.
And except that nothing is allowed.
But when i write
use pubs
select * from sales
I get the entire results.
Plz suggest me a way to block everything except the "select" of customer table.
Thanks!!
Joydeep

View Replies !   View Related

---

Restricted Users &&amp; Xp_cmdshell
Scenario:
SQL Server 2005 SP2.
SQL Server has only Windows Authentication Mode.
SQL server 'xp_cmdshell' option has been disabled by surface area configuration.
A database 'CN01' has been created
I have created a schema 'Executables' that contains stored procedures to access data in 'CN01'.
I have create a database role 'db_procexecutor' with execution permission on schema 'Executables'.
I have created a group 'CN01-Users' in Active Directory.
I have created a login 'CN01-Users' wich has been asigned 'db_procexecutor' role in 'CN01' database.

Problem:
I want a user member of AD group 'CN01-Users' to execute a Stored Procedure in 'CN01' database, (in 'Executables' schema) wich needs access to 'xp_cmdshell' to write a file in OS through bcp command.
The following SP works only assigning 'sysadmin' role to 'CN01-Users'.
For security reasons, I don't want to assign 'sysadmin' role to 'CN01-Users', neither assign permissions on Master.
I want the SP to work in the security scenario described earlier.
Should I use procedure signing ? ... If so, please describe step by step. 

Sample SP:
EXEC sp_configure 'show advanced options', 1
RECONFIGURE WITH OVERRIDE
EXEC sp_configure 'xp_cmdshell', 1
RECONFIGURE WITH OVERRIDE
exec xp_cmdshell 'bcp "SELECT Column FROM CN01.dbo.table" queryout C: able.txt -T -c'
EXEC sp_configure 'xp_cmdshell', 0
RECONFIGURE WITH OVERRIDE
EXEC sp_configure 'show advanced options', 0
RECONFIGURE WITH OVERRIDE
 
Thank you !
Daniel Pérez
Montevideo-Uruguay

View Replies !   View Related

---

Unrestricted Size Vs Restricted
We have "unrestricted" size of log file on model database, but for some reason, all newly created databases have "restricted" sizing.
 
After taking a look at this, it appears that SQL Server changes the "Unrestricted" file growth setting specified on the log file in the model database to "restricted to 2 TB". This size is the maximum allowed for log files by SQL Server 2005, so this means the settings are identical?
 

View Replies !   View Related

---

Restricted File Growth
Hello Everyone,

I appear to be doing something wrong. When I
set my Table for Unrestricted File Growth and
save it, When I go back and look at the settings
it is set back to restricted file growth.

It seems to me if you set any settings and apply
and/or save it. Should it not keep that setting.

Any advice would be great.

Thanks

View Replies !   View Related

---

How Do You Enter Checkbox Status In A Database Column??
Hi,

On my page I am using a wizard control with textboxes to collect data from the visitor.
When they click the finish button - this inserts their data into a Sql database.

On the form is a checkbox.
I dont know what type to use in the database column to accept this and also
how to configure the checkbox on the page so I know if its checked.

Also what would be inserted into the database column "yes" "no" or a numerical value??


Thanks for any advice?

amereto

View Replies !   View Related

---

Database Mail - Status Sent But Email Never Received
From SQL Management Studion I go to Management > Database Mail and I am trying to send a test email but I never receive anything.  I checked my SMTP Mail Server Logs and I saw no entry of my test email. 
I also I checked my SQL Database Mail Logs and everything seems fine, no errors are reported.
The msdb.dbo.sysmail_allitems shows my email status as "sent".
So what am I missing? What steps would you recommend for troubleshooting my problem?
Thank you,
Ric

View Replies !   View Related

---

How To Query The Progress Status Of A Database Restore
Hi,
 
we have a reporting database that needs to be refreshed every week. I normally get a big backup file (50GB) from our business partner very Sunday morning; I have setup a job to restore the database once I got the backup file. The restore job normally will take about 4 or 5 hours to finish, but sometime it may take much longer (more than 10 hours). We knew there is some kind of disk storage contention going on the SAN. When this problem happens the system guy always try to pick my db restore process to be the victim. I hate to kill a job when it has 90% done, but I have no way to tell the restore progress status. Does someone know if I can query database restore progress information from any DMVs?
 
Thank you for your help in advance.
 
David Zhang

View Replies !   View Related

---

How To Recover SQL Server Database From Suspect Status
One of the database in our SQL Server 2000 environment is in the suspect status. We need to bring it back to the normal status. 

 

The problem occurred because the disk on which the data file and log file for this database were placed ran out of space.


Pls note other databases in the same server are working fine.
Later on more space was made available on this disk. We tried the following options but with no success.

1. Reset the status of database and restarted the SQL Server. After restarting the SQL Server, the database once again was showing the suspect status.
2. Used the same data and log file in another SQL Server and attached with the database in this another SQL Server. 
3. Tried dbcc chkdb with repair_allow_data_loss.

 

Since the database is in suspect status, we are neither able to export the data nor able to back up the database.

 

Please suggest some options to recover the database from the suspect status. Also it would be great if we can get the commands, scripts to find if the data/log file is corrupt and a way to correct it (even with data loss is fine).

View Replies !   View Related

---

Can We Toggle The Database Status Between Recovery And Nonrecovery?
Hi,

1) We will setup logshipping for a large database. 

2) 2 systems are located at different city

3) Instead of use 'backup from primary and restore with norecovery to secondary ', we planned to use

    SAN disk clone to get a second set of disks for related database files and log files.

4) We will mount the disk to the secondary server, however, how can we put the database on the new

server as 'norecovery' mode so that we can setup logshipping to this server ??

 

Another easy  example is:

  1) detach  database

   2) Copy database files to another disk

  3) bring the disk to another city and attached to the new server

    The database is recoveryed, how can we attach the database or mount the disk and make

the database as norecovery so that we can keep apply new logs??

 

For 2 identical database image, how can we toggle one from normal to norecovery  to setup logshipping?

Is change 'status' from master database working?

 

Thank you very much for any words.

If this is the wrong forum, please point me to a correct one since I am new here and I can't find a

backup/restore related forum.

 

Jane

 

 

View Replies !   View Related

---

Transaction Rollback Is Used Before It Is Assigned A Value
I am moving some code that was created in visual studio 2002 into Visual Web Developer 2005 express edition and am getting a warning on some of my code before compilation.
The warning is "Variable lSqlTransaction is used before it has been assigned a value.  A null reference exception could result at runtime".  I experienced no problems in vs2002.
The offending line is the rollback command within the exception.  If I move it out of the exception it no longer flags the warning, if I move it after the throw statement it now longer flags the warning.  Any help appreciated.
Heres the code
  Public Shared Sub ExecuteNonQuery(ByVal lSQLCommand As SqlCommand)

Dim lSQLConnection As New SqlConnection(SQLConnString(enmSQLDB.enmSQLDB_TPSDB))
Dim lSQLTransaction As SqlTransaction

Try
'-----------------------------------------------------
'Try and open the database
'-----------------------------------------------------
lSQLConnection.Open()

'-----------------------------------------------------
'Create a transaction
'-----------------------------------------------------
lSQLTransaction = lSQLConnection.BeginTransaction

'-----------------------------------------------------
'Assign the connection and transaction to our object
'-----------------------------------------------------
lSQLCommand.Connection = lSQLConnection
lSQLCommand.Transaction = lSQLTransaction

'-----------------------------------------------------
'Execute the stored proc
'-----------------------------------------------------
lSQLCommand.ExecuteNonQuery()

'-----------------------------------------------------
'Use the transaction to commit the changes
'-----------------------------------------------------
lSQLTransaction.Commit()

Catch ex As Exception
'-----------------------------------------------------
'If any errors have been thrown then roll back without
'commiting....
'-----------------------------------------------------
lSQLTransaction.Rollback()

Throw New Exception("An error has occured whilst trying to update the database. " & _
"Your changes have not been saved.", ex)


Finally
If lSQLConnection.State = ConnectionState.Open Then
lSQLConnection.Close()
End If
End Try

End Sub
 

View Replies !   View Related

---

SSIS Assigned Datatype
I have a problem with datatype mismatches.  In my Data Flow I am reading a Flat File that includes a DateOfBirth which SSIS correctly assigns a datatype of [DT_DATE].  I need to check to see if the record has previously been submitted, so I do a Lookup that uses a SQL statement that combines fields (LastName, Zip & BirthDate) from three different tables.  My problem is that SSIS assigns a datatype of [DT_DBTIMESTAMP] to BirthDate, which I can't use because of the mismatch.  I have tried every form of re-formating the field in SQL that I can think of, but it still gets assigned that DT.  And I'm unaware of a way of changing the DT once SSIS assigns it in the Lookup task.

 

Help!...very frustrated,

Dave

View Replies !   View Related

---

Filegroup %f Has No Files Assigned To It.
I'm tryin to copy information from a fact table from one server to another server but when try using a DTS package to do this, an error pops up that says "the Filegroup <filegroup_name> has no files assigned to it."

what am i missing here?

View Replies !   View Related

---

Trigger-assigned Value Changes When Row Replicates - Why?
Greetings,
 
We have a standard audit trigger on one of our tables.  The trigger type is "after insert, update".  The trigger populates four table columns, telling us the login and time the row was created and last updated. 
 
We use replication to synchronize three servers.  The trigger specifies "not for replication" on all servers.
 
The code used to grab the identity and time of the last update is shown below.
 

LastEditedDate = GETUTCDATE(),

LastEditedBy = SUSER_SNAME()
 
What I observe is that the LastEditedBy value is sometimes different for the same row on different servers even though the time value is identical.  I don't know how to explain this.  It looks like the login value is being recalculated during replication while the edit time is not. 
 
For the record, the correct login will be something like "MYDOMjoe" while the incorrect value on another server will read "NT AUTHORITYNETWORK SERVICE".  Do these symptoms ring a bell with anyone?
 
Thanks,
BCB

View Replies !   View Related

---

Change Owner User Defined Datatype
Hello, We had a developer that created some user defined data types. He is no longer with our company and we want to change owner of those user defined data types so we will be able to delete his UUID. Is their a way to change the owner of the user defined data types from his ID to dbo. I don't see a way to change them with sp_changeobjectowner



Thanks in advance
Jef Wain

View Replies !   View Related

---

How To Change What LOGIN Is Mapped To A Db USER (windows Not SQL)
 

Is there a form of ALTER USER or other option that would allow me to change the Windows-based login associated with a user account?
 
According to BOL, I cannot use the sp_change_users_login trick since I want to rewire up to a Windows login, not a SQL Server login.
 
-- Margo

View Replies !   View Related

---