Viewing 15 posts - 6,241 through 6,255 (of 7,168 total)
I am assuming you are not familiar with the "Script" button in the SSMS Login Properties dialog (and most other dialogs in SSMS).
Make the changes in the SSMS dialog and...
June 6, 2011 at 10:43 am
Uggh, I can empathize. I have always just knocked these cases out manually.
Do you have any util UDFs in place to help with the INT to DATE/TIME conversions in MSDB?...
June 6, 2011 at 10:40 am
XSINIL is a good tip. It is an option if you switch your query from EXPLICIT to ELEMENTS.
June 6, 2011 at 10:36 am
I am not seeing a way to do it in one query...maybe someone else will chime in, but something along these lines may work for you:
USE AdventureWorks2008R2
GO
DECLARE @xml XML =...
June 6, 2011 at 10:22 am
If you go for the videos Gail posted all I can say is buckle in tight, I gave them a listen a while back (at her recommendation) when trying to...
June 6, 2011 at 9:57 am
S t e f (6/6/2011)
HiWe have created an SP that accepts an XML parameter that is validated using an XSD.
Are you sure you bound the schema to the proc parameter...
June 6, 2011 at 9:46 am
When I save just the top portion of your script as a new PS script:
param(
[string]$itype=$(Throw "Parameter missing: -type FULL|DIFF|LOG"),
[string]$iSQLServerInstance=$(Throw "Parameter missing: -SQLServerInstance...
June 6, 2011 at 9:31 am
Bill Tidwell (6/3/2011)
Help me out here. I have no DDL or DML. The sample data included in my post was captured from a raw-data/ ASCII file supplied by...
June 3, 2011 at 1:37 pm
am-244616 (6/3/2011)
Thanks for the reply-e command worked for the question#1,
Excellent!
however for question 1 if the update statement takes more than a min to run, it does not log the...
June 3, 2011 at 1:19 pm
I little over my head so thought I would bring it up here...neat post buried in SSIS forum:
http://www.sqlservercentral.com/Forums/Topic1119608-148-1.aspx
First thoughts: parameter sniffing or parallellism diffs in plans based on diff parameters....
June 3, 2011 at 12:45 pm
Use the -e parameter of sqlcmd.
As an aside...why are you compelled to call sqlcmd from within a T-SQL process using xp_cmdshell? You generally better leaving the default of having xp_cmdshell...
June 3, 2011 at 12:29 pm
Sounds like you're just starting out on the topic...Books Online is usually a good place to look to find a high-level overview as well as examples of the practical applications...
June 3, 2011 at 12:18 pm
Here is the article I think Chris was alluding to:
http://www.sqlservercentral.com/articles/T-SQL/68467/%5B/url%5D
June 3, 2011 at 12:00 pm
I second what Ron said. Help us by providing DDL to create test tables, DML to create test data and your expected results and we'll help you by providing tested...
June 3, 2011 at 11:57 am
Viewing 15 posts - 6,241 through 6,255 (of 7,168 total)