Sunday, October 6, 2013

[SQL Server 2008 issues] get list of log shipping configured databases

[SQL Server 2008 issues] get list of log shipping configured databases


get list of log shipping configured databases

Posted: 05 Oct 2013 05:04 AM PDT

Hi,How can I get list of log shipping configured databases?

How Max Memory works in SQL Server 2008 R2

Posted: 05 Oct 2013 12:41 PM PDT

Hi,I have an instance with Max Memory configured to 8 GB and Min memory configured to 1 GBBut the instance is only taking 3 GB. But PLE is dropping continuously less than 50 secs but there are no active sessions running. why sql instance is not taking only 4 GB even though the Max memory is set to 8 GB?

SQL Restore from SQL Express backup?

Posted: 05 Oct 2013 04:13 AM PDT

Does anyone know of a way to restore a backup from SQLExpress to SQL 2008 R2? I was sent a backup and can't use it without getting it on SQL 2008 R2. Keeps saying I have to restore to SQLEXpress.Thanks,:w00t:

SQL 2008 R2 connection strings with OleDBConnection

Posted: 05 Oct 2013 04:10 AM PDT

I'm relatively new with this version of SQL and haven't coded in a number of years. This is a VB program trying to connect to a SQL 2008 R2 database. I've tried everything I can think of or have read on the blogs. Any help would be appreciated.Here are the particulars:Visual Studio VB 2010 : Code Snippet Dim Provider As String = "SQLOLEDB" Dim DataSource As String = "Local" Dim Database As String = "Jims" Dim UserID As String = "test" Dim pwd As String = "test" Provider = "SQLNCLI10" '<--tried changing the provider here same result 'cn = New OleDbConnection("Provider=SQLNCLI10;Server=Jim-PC;Database=Jims;Uid=Jim-PC\Jim;Pwd=test;") cn = New OleDbConnection("Provider=" & Provider & ";DataSource=" & DataSource & ";Initial Catalog=" & Database & _ ";UserID=" & UserID & ";password=" & pwd & ";") Try cn.Open() '* open access databaseExecuted with two (2) error messagesIndex #0Message Invalid authorization specificationNative:0Source:Microsoft SLServer Native Client 10.0SQL:28000Index #1Message: Invalid connection string atributeNative:0Source: Microsoft SQLServer Native Client 10.0SQL:01s00Content of cn? cn{System.Data.OleDb.OleDbConnection} CanRaiseEvents: True CanRaiseEventsInternal: True CloseCount: 0 ConnectionFactory: {System.Data.OleDb.OleDbConnectionFactory} ConnectionOptions: {System.Data.OleDb.OleDbConnectionString} ConnectionString: "Provider=SQLNCLI10;DataSource=Local;Initial Catalog=Jims;UserID=test;password=test;" ConnectionTimeout: 15 Container: Nothing Database: "Jims" DataSource: "" DbProviderFactory: Nothing DesignMode: False Events: {System.ComponentModel.EventHandlerList} ExecutePermission: {<IPermission class="System.Data.OleDb.OleDbPermission, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" version="1" AllowBlankPassword="False"> <add KeyRestrictions="" KeyRestrictionBehavior="AllowOnly"/> </IPermission> } InnerConnection: {System.Data.ProviderBase.DbConnectionClosedNeverOpened} IsOpen: False LocalTransaction: Write Only Properties are not supported ObjectID: 1 PoolGroup: {System.Data.ProviderBase.DbConnectionPoolGroup} Provider: "SQLNCLI10" ProviderFactory: Nothing ProviderInfo: {System.Data.OleDb.OleDbConnectionPoolGroupProviderInfo} ServerVersion: {"Invalid operation. The connection is closed."} Site: Nothing State: Closed {0} UserConnectionOptions: {System.Data.OleDb.OleDbConnectionString}

SQL Server Database Backup Monitoring

Posted: 29 Sep 2013 11:53 PM PDT

Hi SQL Masters,Greetings!Do you have a script that will determine if the backup failed/succeeded?Sample output:Database Name Status Log Date--------------- ---------- --------------AdventureWorks2008 FAILED 20130125AdventureWorks2008 SUCCEEDED 20130126Something like that.....Any ideas SQL Masters?Thank you and Best Regards,

DBMAIL QUERY RESULT IN HTML FILE

Posted: 04 Oct 2013 07:15 PM PDT

Dear,I require to send a file as attachment that is generated from a query result. Usually the attachment is with ".dat" extension. Now I want that the attachment should be in html format.Please any idea would help me a lot.RegardsAkbar

No comments:

Post a Comment

Search This Blog