Viewing 15 posts - 1,231 through 1,245 (of 9,643 total)
If you have it in a group (details are a group) you can say Keep Together.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 18, 2013 at 1:53 pm
You need to get rid of the single-quotes and replace the @ with a :. Check out this blog post
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 18, 2013 at 1:43 pm
What application are using to connect to SQL Server? Are you on a domain?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 18, 2013 at 1:29 pm
You can start with this article.
If you want to see the information in your trace you probably need to add sql:batch_starting and sql:batch_completed.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 17, 2013 at 9:40 am
Another option would be creating a master server and creating the job there. Start with this BOL topic
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 17, 2013 at 9:19 am
Your issue is that the Blocked Process Report Event does not include the DatabaseName column, so you can't filter on it for that event. You need to use the...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 17, 2013 at 7:38 am
The same reason you'd create an assembly for any development project, code re-use. You may have a need for some kind of custom conversion that will be used by...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 17, 2013 at 7:27 am
According to this you should be able to.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 17, 2013 at 7:22 am
I would agree with your preference. If you do everything locally and then push to the dev server you aren't stepping on each other's toes during development and unit...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 17, 2013 at 7:07 am
Windows accounts. Running from a query window means it is running using the SQL Server Service account.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 17, 2013 at 6:56 am
You can create a server group in SSMS (Registered Servers tab), right-click on the group and select new query. Then the query will be run against all the servers...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 16, 2013 at 3:22 pm
Sounds like you haven't setup the project configuration. See how here.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 16, 2013 at 3:18 pm
I'm not sure I understand what you need to do. Based on what you have provided you could be doing either of these 2 things:
Get a full backup and...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 16, 2013 at 3:15 pm
It is running under the SQL Agent service account when you run it in a job. I believe you need to create a proxy
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 16, 2013 at 2:57 pm
Sqlsavy (9/16/2013)
Query 1 and query 2 takes approximately two minutes to run but query 3 takes around 9 hours which was...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 16, 2013 at 8:06 am
Viewing 15 posts - 1,231 through 1,245 (of 9,643 total)