[SQL Server 2008 issues] Monitoring Connections to Databases |
| Monitoring Connections to Databases Posted: 17 Aug 2010 12:48 AM PDT Hi - I have a task to provide a list of applications that connect to one of my databases. I'd like to setup a monitor for a week time so that I have a window. I know I can go in to Activity Monitor and manually see this. But is there a built in funtion or a script I can write to be able to log all connections to this specific database? I'm running SQL 2005.Thank you,Kevin OkonSr. Systems EngineerPCB Piezotronics, Inc. |
| Posted: 05 Apr 2013 08:27 PM PDT When i am trying to shift msdb database from it's default path(C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA) to another drive(E:\). After shifting the database i am getting error as shown below.(the error i am getting while expanding database node in SSMS an d now i am not able to access any database.)Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476------------------------------ADDITIONAL INFORMATION:An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)------------------------------Database 'msdb' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details. (Microsoft SQL Server, Error: 945)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.2531&EvtSrc=MSSQLServer&EvtID=945&LinkId=20476------------------------------The procedure i followed to shift msdb database is as follows:1. For each file to be moved, run the following statement. ALTER DATABASE msdb MODIFY FILE ( NAME = MSDBData , FILENAME = 'E:\MSDBData.mdf' ) ALTER DATABASE msdb MODIFY FILE ( NAME = MSDBLog , FILENAME = 'E:\MSDBLog.ldf' )2. Stop the instance of SQL Server to perform maintenance.3. Move the file or files to the new location.4. Restart the instance of SQL Server or the server.Also i did confirm the path by running following query SELECT name, physical_name AS CurrentLocation, state_desc FROM sys.master_files WHERE database_id = DB_ID(N'msdb');And output was showing current location of both MSDBdata and MSDBLog as E:\This error happened while i did it for testing server. I want to do it for a production server. So please help me on this error. How exactly to shift msdb database? |
| Help on building a pivot query Posted: 05 Apr 2013 10:22 PM PDT Hi,Am having difficulty writing a pivot query as am pretty new to this. In the attached word document I have given example of the sample table and explained in bried what am trying to acheive.Could anyone pls help me write a query to get % of rows to acheive the desired output.thanks |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / SQL Server 2008 - General To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment