Viewing 15 posts - 121 through 135 (of 3,221 total)
Have you examined / evaluated the use of Change Data Tracking. If not you may want to start here"
http://msdn.microsoft.com/en-us/library/bb933875(v=sql.105).aspx
March 10, 2013 at 6:08 pm
This might be what you need.
EXECUTE sp_msforeachdb 'USE ?
IF DB_NAME() NOT IN(''master'',''msdb'',''tempdb'',''model'')
PRINT DB_NAME()'
Returns:
ReportServer
ReportServerTempDB
Test2008K
Test2012
SSISDB
Scores
TIPSNTRICKS
VaTax
TestPartition
AdventureWorks2012
QOD100
To learn more about this...
March 7, 2013 at 4:15 pm
For my own learning experience, following Glenn Berry's blog posting here is a query I fashioned
DECLARE @LookF VARCHAR(9)
SET @LookF = 'procedure'
SELECT...
March 7, 2013 at 8:03 am
Here is an excellent source for information on Extended Properties by Glenn Berry
which I believe will provide you with the information you requested.
March 7, 2013 at 7:18 am
Agree with the title of the QOD being missleading, and to make sure people do NOT conclude, incorrectly, how ISNUMERIC works may I suggest that every one read this...
March 6, 2013 at 9:45 am
Stuart Davies (3/5/2013)
Very good question Demonfox - thanks.Took four re-reads and two cups of coffee before getting my point this morning
+1
March 5, 2013 at 7:08 am
With over 2 hrs since you posted your request and no one has answered . might I suggest that you supply a sample (10 to 15 lines / addresses), the...
March 1, 2013 at 2:58 pm
Items I believe you should consider. (Not knowing your exact operation).
1. I assume that you have NOT found any evidence/documentation left by your predecessor(s) as to why...
February 28, 2013 at 2:49 pm
malleswarareddy_m (2/26/2013)
Thanks for great question. Please keep on posting QOTD Ron. You question and answers are always good.
Thank you ..............
February 27, 2013 at 6:44 am
L' Eomot Inversé (2/27/2013)
February 27, 2013 at 6:37 am
Koen Verbeeck (2/26/2013)
Eazy peezy. Thanks for the question.
+1
February 26, 2013 at 6:28 am
bitbucket-25253 (2/25/2013)
L' Eomot Inversé (2/25/2013)
No QotD yet today? Has everyone stopped submitting them?
Was wondering was it my link that failed to show the current QOD, so your note relieved...
February 25, 2013 at 5:22 pm
L' Eomot Inversé (2/25/2013)
No QotD yet today? Has everyone stopped submitting them?
Was wondering was it my link that failed to show the current QOD, so your note relieved me...
February 25, 2013 at 3:52 pm
May I suggest as a first step in your upgrade task using the UPGRADE ADVISOR
http://msdn.microsoft.com/en-us/library/ms144256.aspx
2. If you have "extra" hardware available purchase a copy of the DEVELOPER EDITION of...
February 24, 2013 at 11:15 am
To help those who want to assist you ... can you post the table definitions, some sample data.
To do this quickly and easily please click on the first link in...
February 23, 2013 at 2:52 pm
Viewing 15 posts - 121 through 135 (of 3,221 total)