Viewing 15 posts - 8,461 through 8,475 (of 19,564 total)
I personally like the compression that Redgate Backup provides. I also prefer restoring from Redgate over the native due largely to how much easier it is - as Jeff...
September 29, 2011 at 8:35 am
How many of us keep that "junk drawer" full of scripts that seem like they could be useful. Just collect a ton of scripts and maybe you will use...
September 28, 2011 at 11:46 pm
Based on what you are providing the problem does not match the data.
It appears that you may have a Definition ID that has multiple descriptions but different categories. If...
September 28, 2011 at 9:15 pm
You can get to sys.dm_exec_sessions via sys.dm_exec_requests. Use sql_handle and/or plan_handle from sys.dm_exec_query_stats to join to sys.dm_exec_requests. Then use session_id to get to sys.dm_exec_sessions.
This is all assuming that...
September 28, 2011 at 9:11 pm
I am curious to see the error message if one is present.
September 28, 2011 at 9:05 pm
If going 3rd party I would certainly go with Red-Gate. For the most part, I use the native tools though.
I have tried several 3rd party tools and none compare...
September 28, 2011 at 9:03 pm
SELECT ProductCode,ProductName,RTRIM(LTRIM(Substring(deliveryText, start -1, length - start - fromEnd + 3))) AS [extracted]
FROM (
SELECT ProductName,MAX(PATINDEX([Matched], ProductName)) AS start
...
September 28, 2011 at 3:22 pm
Looks like I missed a column named tabletext - replace it with ProductName and the script should run.
September 28, 2011 at 3:09 pm
Browse can just read. Scott must be a member of another group that is a member of a more privileged role.
September 28, 2011 at 3:02 pm
Try this
SELECT ProductCode,ProductName,RTRIM(LTRIM(Substring(deliveryText, start -1, length - start - fromEnd + 3))) AS [extracted]
FROM (
SELECT ProductName,MAX(PATINDEX([Matched], ProductName)) AS start
...
September 28, 2011 at 2:59 pm
Viewing 15 posts - 8,461 through 8,475 (of 19,564 total)