Viewing 15 posts - 1,231 through 1,245 (of 9,641 total)
What application are using to connect to SQL Server? Are you on a domain?
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.
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
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...
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...
September 17, 2013 at 7:27 am
According to this you should be able to.
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...
September 17, 2013 at 7:07 am
Windows accounts. Running from a query window means it is running using the SQL Server Service account.
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...
September 16, 2013 at 3:22 pm
Sounds like you haven't setup the project configuration. See how here.
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...
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
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...
September 16, 2013 at 8:06 am
Had a good weekend in Orlando for SQLSaturday 232. As usual the crew down there did a great job organizing. My session went well and was pretty well...
September 16, 2013 at 7:00 am
dwain.c (9/12/2013)
Jack Corbett (9/12/2013)
Brandie Tarvin (9/12/2013)
Go to http://www.sqlsaturday.com and see if there is a way to register for event notifications. That way if one pops up near you...
September 13, 2013 at 10:50 am
Viewing 15 posts - 1,231 through 1,245 (of 9,641 total)