Thursday, August 15, 2013

[MS SQL Server] How to migrate DTS packages from SQL 2000 to SQL 2008R2

[MS SQL Server] How to migrate DTS packages from SQL 2000 to SQL 2008R2

How to migrate DTS packages from SQL 2000 to SQL 2008R2

Posted: 15 Aug 2013 03:33 AM PDT

How to migrate DTS packages from SQL 2000 to SQL 2008R2.Or atleast let me know how to migrate DTS packages in SQL 2000 to SSIS packages SQL 2008R2

System-health extended-event session does not capture latest deadlocks

Posted: 20 Dec 2012 08:04 PM PST

While running the following query to capture the latest deadlocks recorded in the default system-health extended-event session, I noticed that the latest deadlock captured was 3 days ago. However, in the SQL ERRORLOG I see that several deadlocks have occurred as recently as today.Has anyone else noticed this issue?[code="sql"]--http://www.quest.com/whitepaper/how-to-use-sql-servers-extended-events-and-notifications816315.aspx;WITH SystemHealthAS ( SELECT CAST ( target_data AS xml ) AS SessionXML FROM sys.dm_xe_session_targets st INNER JOIN sys.dm_xe_sessions s ON s.[address] = st.event_session_address WHERE name = 'system_health')SELECT Deadlock.value ( '@timestamp', 'datetime' ) AS DeadlockDateTime, CAST ( Deadlock.value ( '(data/value)[1]', 'Nvarchar(max)' ) AS XML ) AS DeadlockGraphFROM SystemHealth sCROSS APPLY SessionXML.nodes ( '//RingBufferTarget/event' ) AS t (Deadlock)WHERE Deadlock.value ( '@name', 'nvarchar(128)' ) = N'xml_deadlock_report'ORDER BY Deadlock.value ( '@timestamp', 'datetime' );[/code]

How can I change a user created without login to a user with login

Posted: 14 Aug 2013 07:56 PM PDT

We lost a raid controller (supposedly) on a brand new database server Wednesday at about 3:45pm. Just before our 4:00 backup. I'm trying to attach our main database and get it running at that closest point.We have reinstalled SQL Server 2008 R2 (long story talk to DELL)I am able to attach the 3:45 mdf and ldf files but the users are without logins.How can I get the db users to have a login and password again?Before 6:00am this morning ..... central time USA.its 3:55am now.This is an emergency and any help is sincerely appreciated.tia,Todd

Emailing from SQL 2008 using 'EX:\O' type addresses

Posted: 14 Aug 2013 09:44 PM PDT

I'm trying to do the simple task of sending emails to end-users when their case is closed on the database.Normally I simply use DBMail and sp_send_mail; no problems.But the only email addresses available are of the form 'EX:/O=xxx/OU=site/cn=Recipients/cn=nnn.mmmm' which I am given to understand arise from Exchange. Anyway I can't get them to work, and so far haven't found anything about it on the net.Anyone have an idea? All offers gratefully accepted.thanks
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog