Script To Log/record The Users Who Accessed My Database

Jul 10, 2006

Hi,

I am hosting my database on a third-party Microsoft SQL server. The guest user is "Off". But, I am not sure if any one else is accessing/viewing/editing my database contents.

Can I know/log/record the users/logins who are viewing/accessing my database. Is there any script or any exisitng machnism which can be used to track these users.

Also, are there any things that I should take care with my database from outside users.

Thanks
-Sudhakar

View 1 Replies

Script To Log/record The Users Who Accessed My Database

Jul 10, 2006

View 2 Replies View Related

Script To Log/record The Users Who Accessed My Database

Jul 10, 2006

View 1 Replies View Related

Transact SQL :: Log What Users Accessed Which Databases

Nov 9, 2015

I'd like to find out who is accessing various databases and log the time they did so.

Is there a way to do this? I just need the account name and the time logged and then to write to a table so I can query it.

View 2 Replies View Related

SQL Server Admin 2014 :: List Of Users That Accessed A Table

Jul 22, 2015

I'm trying to find out what tables are being used in a Database.

I don't want the last User but the User and the Dates.

I have a script that return the last user but that is not going to work.

The following script returns the last user but not all users and the Login Name:

ITH LastActivity (ObjectID, LastAction) AS
(
SELECT object_id AS TableName,
last_user_seek as LastAction
FROM sys.dm_db_index_usage_stats u
WHERE database_id = db_id(db_name())

[Code] .....

View 2 Replies View Related

Transact SQL :: Fine Tune Procedure / Accessed By Multiple Users

Oct 13, 2015

i have a report that runs on a huge table rpt.AgentMeasures , it has 10 months worth of data (150 million records as of today and will keep increasing). i have pasted my proc below , the other tables that are joined to this huge table do not have more then 3k records.This report will be accessed by multiple users (expecting 20 ppl). as of now this reports runs for 5 mins if i pull for 1 month worth of data. if it is wise to use temp tables.

ALTER proc [rpt].[Get_Metrics]
@MinDate DATETIME,
@MaxDate DATETIME,
@Medium Varchar(max),
@footPrint varchar(max),

[code]...

View 10 Replies View Related

What Is The Solution For This Internal Error EnsureMyReportsExists: Users Folder Not Found When My Reports Accessed

Nov 1, 2007

Any help would be apprecaited....

aspnet_wp!library!1!11/01/2007-09:36:59:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., EnsureMyReportsExists: Users folder not found when My Reports accessed.;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
aspnet_wp!library!1!11/01/2007-09:37:04:: i INFO: Exception dumped to: C:Program FilesMicrosoft SQL ServerMSSQL.4Reporting ServicesLogFiles flags= ReferencedMemory, AllThreads, SendToWatson
aspnet_wp!webserver!1!11/01/2007-09:37:04:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.

10/31/07 14:54:06, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)
10/31/07 14:54:06, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
10/31/07 14:54:06, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 2160
10/31/07 14:54:06, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
10/31/07 14:54:06, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
10/31/07 14:54:06, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
10/31/07 14:54:06, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x053F5860
10/31/07 14:54:06, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
10/31/07 14:54:06, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x00000000
10/31/07 14:54:06, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x00000000
10/31/07 14:54:06, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
10/31/07 14:54:06, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
10/31/07 14:54:06, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
10/31/07 14:54:06, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
10/31/07 14:54:06, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 15 not used
10/31/07 14:54:10, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
10/31/07 14:54:10, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:Program FilesMicrosoft SQL ServerMSSQL.4Reporting ServicesLogFilesSQLDmpr0001.mdmp
10/31/07 14:54:10, ACTION, aspnet_wp.exe, Watson Invoke: No
10/31/07 15:25:56, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)
10/31/07 15:25:56, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
10/31/07 15:25:56, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 2160
10/31/07 15:25:56, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
10/31/07 15:25:56, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
10/31/07 15:25:56, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
10/31/07 15:25:56, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x07E31E9C
10/31/07 15:25:56, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
10/31/07 15:25:56, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x00000000
10/31/07 15:25:56, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x00000000
10/31/07 15:25:56, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
10/31/07 15:25:56, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
10/31/07 15:25:56, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
10/31/07 15:25:56, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
10/31/07 15:25:56, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 15 not used
10/31/07 15:25:59, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
10/31/07 15:25:59, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:Program FilesMicrosoft SQL ServerMSSQL.4Reporting ServicesLogFilesSQLDmpr0002.mdmp
10/31/07 15:25:59, ACTION, aspnet_wp.exe, Watson Invoke: No
10/31/07 15:28:01, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)
10/31/07 15:28:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
10/31/07 15:28:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 2160
10/31/07 15:28:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
10/31/07 15:28:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
10/31/07 15:28:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
10/31/07 15:28:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x07E32A04
10/31/07 15:28:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
10/31/07 15:28:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x00000000
10/31/07 15:28:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x00000000
10/31/07 15:28:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
10/31/07 15:28:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
10/31/07 15:28:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
10/31/07 15:28:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
10/31/07 15:28:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 15 not used
10/31/07 15:28:04, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
10/31/07 15:28:04, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:Program FilesMicrosoft SQL ServerMSSQL.4Reporting ServicesLogFilesSQLDmpr0003.mdmp
10/31/07 15:28:04, ACTION, aspnet_wp.exe, Watson Invoke: No
10/31/07 15:29:31, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)
10/31/07 15:29:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
10/31/07 15:29:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 2160
10/31/07 15:29:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
10/31/07 15:29:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
10/31/07 15:29:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
10/31/07 15:29:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x07E3356C
10/31/07 15:29:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
10/31/07 15:29:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x00000000
10/31/07 15:29:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x00000000
10/31/07 15:29:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
10/31/07 15:29:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
10/31/07 15:29:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
10/31/07 15:29:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
10/31/07 15:29:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 15 not used
10/31/07 15:29:34, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
10/31/07 15:29:34, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:Program FilesMicrosoft SQL ServerMSSQL.4Reporting ServicesLogFilesSQLDmpr0004.mdmp
10/31/07 15:29:34, ACTION, aspnet_wp.exe, Watson Invoke: No
10/31/07 15:31:14, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)
10/31/07 15:31:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
10/31/07 15:31:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 2160
10/31/07 15:31:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
10/31/07 15:31:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
10/31/07 15:31:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
10/31/07 15:31:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x07E340D4
10/31/07 15:31:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
10/31/07 15:31:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x00000000
10/31/07 15:31:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x00000000
10/31/07 15:31:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
10/31/07 15:31:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
10/31/07 15:31:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
10/31/07 15:31:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
10/31/07 15:31:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 15 not used
10/31/07 15:31:17, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
10/31/07 15:31:17, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:Program FilesMicrosoft SQL ServerMSSQL.4Reporting ServicesLogFilesSQLDmpr0005.mdmp
10/31/07 15:31:17, ACTION, aspnet_wp.exe, Watson Invoke: No
10/31/07 15:37:52, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)
10/31/07 15:37:52, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
10/31/07 15:37:52, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 2160
10/31/07 15:37:52, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
10/31/07 15:37:52, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
10/31/07 15:37:52, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
10/31/07 15:37:52, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x07E34C3C
10/31/07 15:37:52, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
10/31/07 15:37:52, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x00000000
10/31/07 15:37:52, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x00000000
10/31/07 15:37:52, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
10/31/07 15:37:52, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
10/31/07 15:37:52, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
10/31/07 15:37:52, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
10/31/07 15:37:52, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 15 not used
10/31/07 15:37:54, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
10/31/07 15:37:54, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:Program FilesMicrosoft SQL ServerMSSQL.4Reporting ServicesLogFilesSQLDmpr0006.mdmp
10/31/07 15:37:54, ACTION, aspnet_wp.exe, Watson Invoke: No
11/01/07 09:37:01, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)
11/01/07 09:37:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
11/01/07 09:37:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 260
11/01/07 09:37:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
11/01/07 09:37:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
11/01/07 09:37:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
11/01/07 09:37:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x47405860
11/01/07 09:37:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
11/01/07 09:37:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x00000000
11/01/07 09:37:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x00000000
11/01/07 09:37:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
11/01/07 09:37:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
11/01/07 09:37:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
11/01/07 09:37:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
11/01/07 09:37:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 15 not used
11/01/07 09:37:04, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
11/01/07 09:37:04, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:Program FilesMicrosoft SQL ServerMSSQL.4Reporting ServicesLogFilesSQLDmpr0007.mdmp
11/01/07 09:37:04, ACTION, aspnet_wp.exe, Watson Invoke: No

View 6 Replies View Related

Is There Anyway To Tell When A Database Was Last Accessed Or Changed?

May 29, 2007

Is there a simple way to tell when a database was last accessed or changed?

We have some databases on old servers which we would like to discontinue but do not know if they are being used.

We would rather not just take them offline.

Is there anyway I can find out if they are still being used?

Please help if you can.

Regards, Major (that is my Christian name ;-)

View 3 Replies View Related

How Do I Find When My Database Was Last Accessed

Dec 11, 2007

I have a bunch of datbases I have created during the development process. I want to delete those no longer being used. How do I find when the last time a database was accessed?

Thanks.

View 3 Replies View Related

Need Help To Check When Was Database Last Accessed/updated

Jul 29, 2004

I am trying to manage a sql server.

In this sql server, I have about 200 databases.

Is there any way/suggestions to check to see if some of the database has not been accessed/updated for the last month or longer?

I am trying to develop a system to remove the database that's no longer needed.

Thank you.

View 8 Replies View Related

SQL Server 2008 :: Database Can't Be Accessed

Apr 9, 2015

I was having issue with one of my databases in SQL EXPRESS. It is offline this morning …it said “Database 'MyDB' cannot be opened due to inaccessible files or insufficient memory or disk space. When I checked the error log ..it only said “FCB::Open failed: Could not open file D:DatabasesMyDB_Data.mdf for file number 1. OS error: 32(failed to retrieve text for this error. Reason: 15100).

I did alter database offline and and online ..it works for me( I can access the database again but I need to find the cause of this issue )I checked the max memory setting is still by default .. not limited for SQL ..it could be the cause ?

View 9 Replies View Related

DB Engine :: Last Accessed Database Date

Jul 22, 2015

how to check the last accessed date of the list of all databases in a particular server in MS SQL SERVER.

View 12 Replies View Related

DB Engine :: Restore Database When It Is Accessed By Application?

Oct 5, 2015

Our application team make design changes of the database in their development server and asks me to restore the bak file from the development server into the production server with replace command. The database in the production server is connected to the application server and so when I try to restore the database error message comes that the database is in use.

So first I find out the sessions with the logins who is the user in the database with sys.dm_exec_sessions joined with sys.dm_exec_requests and then kill the sessions. And after that it is possible to restore. But many times when I kill the session and try to restore in between new sessions comes into effect which are generated from the web server and many times I have to resubmit the query in the dmv's and find the sessions and kill it again and again before restore can be done. Is there any correct method to restore an active database which is being accessed by the application from a web server with out stopping the web server?

View 6 Replies View Related

Why Out Of The Blue Would VPN Users Be Unable To Connect To Database And Local Users Are Unaffected?

Mar 6, 2008

I have had this issue just pop up. I have local users who can connect fine, but my users that require connection by VPN cannot connect. I get the server not available or access denied error. I did confirm that the VPN'ers are connected to the network correctly and can see that their shares and mappings are correct. Any ideas? Thanking you all in advance!!

View 6 Replies View Related

SQL Server 2008 :: How To Find If A Database Has Been Accessed / Used Since Last Month

Jul 6, 2015

Is there anyway I can find or make a report if a databases has been accessed/used since last month?

View 4 Replies View Related

SQL Tools :: When Was Database Last Accessed By Each User / Login In Server

Jul 6, 2015

I have a plan of decommissioning of unused databases which are not been in use for quite some time. is there any simple way/t-sql to find out When was the database last accessed by each user/login in sqlserver.

View 2 Replies View Related

Data Reside In Memory And Accessed Via CLR Database Objects.

Nov 7, 2007

Hi,
I want to manage memory relational data in the memory(Insert, delete, return) and manipulate the data via SQL 2005 and CLR database objects.
The gool is to manage a table that relatively has a lot of inserts and deletes which takes a lot of IO operations and i want to reduce it. the data itself is not permanant each row deleted from the table after 15-20 minutes.
I looked at the extended stored procedure and other CLR enable objects and it seams that they all return data from the database itself.
How can i return data that is reside in the memory?
Thanks.

View 2 Replies View Related

Record Of Report Users

Oct 24, 2007

Hi, Is it possible to find out who has accessed a certain report for a given time period?
Does Reporting Services store this data somewhere?
If so how can I access it?

TIA

View 5 Replies View Related

Difference Between Database -- &&> Users And Security --&&> Users

Nov 28, 2006

Hi Team,

In SQL Enterprise Manager, when we expand "Database -->Users", we see the

users there. When we expand "Security --> logins" we see the same users there.

Can you differentiate these two.

Thanks

Santhosh

View 1 Replies View Related

T-SQL (SS2K8) :: Creating Database Where Each Record Is Required To Have Twin Record In Database

May 12, 2014

,I am creating a database where each record is required to have a twin record in the database.These is a type a value and a type b value and both must be present for the record to be valid.

Customer_ID, Order_Type, Product_Code
54, a, 00345
54, b, 00356

Is this something that would have to be done programmatically, or is it possible to create a constraint of some sort to ensure this?

View 8 Replies View Related

Restore Of Database Backup To Another Database Makes Users DBO

May 7, 1999

Anybody figure a way around this:

In a development server you take a backup and you want to move the entire database to a production server. The production server does not contain the database, users, or logins in master.

When you restore the backup to production in 7.0, the users get moved to DBO because the logins do not exist and then you cannot delete them.

We are having to drop the users from the database on development, back up the database and restore it to production, then recreate the users on production.

This is bogus and did not happen in 6.5 because of the aliases.

Anybody come up with a better way?

View 1 Replies View Related

After Replicating A Database, SP's In The Same Database Are Not Able To Modify By Other Users.

May 21, 2008

hi there,

After replicating a database, the stored procedures in that same database are not able to edit by other users than service account (sys admin users), When the normal users try to edit any of the stored procedures, sql server 2005 is throwing the following error...

Msg 21050, Level 16, State 1, Procedure sp_MSmerge_ddldispatcher, Line 12Only members of the sysadmin fixed server role or db_owner fixed database role can perform this operation. Contact an administrator with sufficient permissions to perform this operation.

any suggessions are most welcome.

by
CHINNASAMY

View 1 Replies View Related

Users Database

Jan 31, 2008

how can i create a users database to store users infos (names pictures...) ??
thx for taking time to read this

View 2 Replies View Related

How To Tell If Accessed

Nov 30, 2004

I just got assigned to be our companies sql server dba, there are about 80 databases on various servers. I am suspecting many are not even used. Is there a way for me to tell the last time they were accessed and by whom? And, more importantly, the last time any changes have been made in the database? Thanks in advance.

View 7 Replies View Related

Accessing Database Users

Feb 8, 2007

Hi,
I would like to know if there is any way of Accessing database users from frontend and changing their persmissions.
Thanks
Niranjana.

View 10 Replies View Related

Users Not Listing In Database.

Jan 25, 2001

Hello Experts,

I copied a database from my production server to the development server and now i dont see the users in the database from the enterprise manager,database and users folder. But, When i run a query to against the sysuser table from a query analyser I can see those users here. Why cant I see in from the Enterprise manager. Any advice please..

Appreciated any comments on this.
Thanks,

Vilke.

View 2 Replies View Related

How To Force Users From A Database?

Dec 1, 2000

Does anyone know a way to force out all users from a particular database? I need to script this to perform some maintenance at a particular time every day.

Thanks for your help,

Les

View 2 Replies View Related

Dropping Users In Database

Dec 23, 1999

Is there a way in SQL to drop any users from a database. I am trying to schedule some nightly DB maintenance and some users are still in there sometimes. I need to be able to kick the out to do dbcc checkdbs, etc. Is there a way for me to do this without stopping the SQL services?

View 3 Replies View Related

Database Users...URGENT!!

Jun 15, 2000

I restored a database from one full backup.The users are missing now in the new databse.When I try to create the same users again it says that they are already existing!Please help what shall I do to restore/recreate the users?Do I need to do anything with the Master?

View 4 Replies View Related

Copying Users From One Database To Another

Feb 25, 2001

I have a question regarding copying users from one server to another that are running different versions of Microsoft Sequel Server.

I have Server A running 6.5 version and Server B running 7.0 version. How can I copy just the list of users from Database1 on Server A to Database2 on Server B.

Can anyone help me.

Thanks.

Lakshmi.

View 2 Replies View Related

Users Cant Access New Database

Dec 22, 2004

EMERGENCY 911 HELP PLEASE

Ok I created a database SQL is the engine and Access XP is the gui. When the users try to access the databae they get error message, it opens up but they cant open the forms for some reason. I was wondering if this had to do with me have Access XP and them having Access 2000, but I highly doubt it because when I had a user log on to my machine (which has access xp) they still were not able to access the forms. Can someone help me out PLEASE PLEASE PLEASE... this is so frustrating :(

One thing I'm noticing is that the users connection keeps dropping???

View 12 Replies View Related

Export Database Users

Nov 1, 2005

Hi, guys

I has a question for you:

How can i Export the users and permisions and restore it again?

Thanks in advance

View 4 Replies View Related

No Dbo For A Database - But There Are Db_owner Users

Aug 27, 2006

I have a number of user databases who have lost their owner. That is, displaying properties for the database says the owner is unknown.

I assume that any user for such a database that's assigned to the db_owner role can admin everything in this database? Which means that the lack of a dbo doesn't cause any other problem than making it impossible to run a sp_helpdb for the database, or...?

Of course I'd like to make someone the owner, but it seems difficult to make an already existing database user the owner, without dropping the user and re-creating it.

View 3 Replies View Related