The_SQL_DBA (2/20/2013)

---

Thanks for the replies folks.

@george - I am not sure if they support DNS alias, but if they do it will be awesome as Mirroring is our go to...

Does this help?

http://msdn.microsoft.com/en-us/library/ms187611.aspx

You can't can't specify the failover partner in the connection string? That's how we did it for the PeopleSoft HR and Finance systems at a previous employer.

No changes to...

The last article I reference in my signature block talks about managing the transaction log, you should read it.

Sounds like your database is using BULK_LOGGED or Full Recovery model and you aren't running any transaction log backups. Full backups and Differential backups do not truncate the transaction...

So, what is the result of the following query?

select name, log_reuse_wait_desc from sys.databases where name = 'Aquapak_Live_app';

This is how it should be executed:

exec dbo.SetDefaultDatabase @LoginString = '[Sample/abc]', @DatabaseString = 'ThisDatabase';

Not familiar with the extended events. All I can think of is the sp_statement_starting is conting the start of each SQL statment in the procedure each time one is...

This maybe?

CREATE Procedure [dbo].[SetDefaultDatabase]

@LoginString NVARCHAR(50),

@DatabaseString NVARCHAR(50)

As

Begin

Set NoCount On

Exec sp_defaultdb @loginame = @LoginString, @defdb = @DatabaseString

End

GO

How many SQL statements are there in the stored procedure?

jfogel (2/19/2013)

---

Lynn Pettis (2/19/2013)

---

If documentation exists and you fail to read it, you have only yourself to blame. Just pointing out one of the possible reasons you may not...

I apologize if you are taking the use of the word "you" personally. It was meant in a general third person manner.

If documentation exists and you fail to read it, you have only yourself to blame. Just pointing out one of the possible reasons you may not know why a...

Try either of these:

SELECT AttachmentKey

FROM dbo.order

WHERE NOT( (AttachmentKey IS NULL)) OR (AttachmentKey = '') )

OR

SELECT AttachmentKey

FROM dbo.order

WHERE (AttachmentKey IS NOT NULL) AND (AttachmentKey <> '')

Looking at the following, if AttachmentKey is '', then AttachmentKey IS NULL is false, which then becomes true due to the NOT which makes this part of the WHERE clause...