Comments
Sort by recent activity
To avoid a syntax error you'll probably need to dummy out the linked server. Just give it the same name as the one in production (or wherever) but you can point it to whatever you need to in order for it to work. It doesn't have to be the same server. It just has to have the same name locally. / comments
To avoid a syntax error you'll probably need to dummy out the linked server. Just give it the same name as the one in production (or wherever) but you can point it to whatever you need to in order ...
I used "Align subsequent items with first item", "Align items across clauses" and "Align items to tab stops". It seemed to be what you were looking for based on the initial post. / comments
I used "Align subsequent items with first item", "Align items across clauses" and "Align items to tab stops". It seemed to be what you were looking for based on the initial post.
There were changes to the formatting, especially the defaults. However, you should have control over those alignments, way more than before. Click on the SQLPrompt menu and then "Edit Formatting Styles..." to get started. / comments
There were changes to the formatting, especially the defaults. However, you should have control over those alignments, way more than before. Click on the SQLPrompt menu and then "Edit Formatting St...
OK, there's a lot to this. Best recommendation, check out the documentation located here. What you're looking for is Build. That's the one that's going to let you do the comparison and generate scripts and output. Sync will actually do the move after you've completed the Build. Come back here after you check that out if you have more questions.
As to C#, I don't know. I've only done this work using PowerShell and the examples will show that. I'll see if I can get someone to show that for you.
You can pass in a filter to the Build process.
You can distribute the artifacts you generate, but if you need to do a compare to each of the clients to generate that artifact, that's tougher. We'd need to drill down on what you're doing, why and how. / comments
OK, there's a lot to this. Best recommendation, check out the documentation located here. What you're looking for is Build. That's the one that's going to let you do the comparison and generate scr...
To validate this works, I just connected an Azure SQL Database to my Team Foundation Services source control. Everything ought to work.
Make sure you have the latest version. I think some of the older versions had a problem with Azure. / comments
To validate this works, I just connected an Azure SQL Database to my Team Foundation Services source control. Everything ought to work.
Make sure you have the latest version. I think some of the ol...
It’s pretty straightforward. You have a “Sql Prompt” menu in SSMS or VS. Click on that and then select “Edit Formatting Styles”. It’ll open up the new editor. It’s really slick. You can edit the default style or create a new one. I’d go for creating a new one to start. Then just step through all the different options and save the work when you’re done. As you make changes you can see a sample query or even preview the current query. It makes it really easy to get exactly what you want in terms of style. We even have a nice article telling all about it.
Hope that helps / comments
It’s pretty straightforward. You have a “Sql Prompt” menu in SSMS or VS. Click on that and then select “Edit Formatting Styles”. It’ll open up the new editor. It’s really slick. You can edit the de...
This looks like some kind of bot defining two terms, not even remotely answering the question. / comments
This looks like some kind of bot defining two terms, not even remotely answering the question.
Not a problem. I'm here to help out. / comments
Not a problem. I'm here to help out.
Yes. If you go into the Alerts management window, on the left side of the screen you'll see your servers. You can drill down to an instance and then drill down on the instance. You'll see a list of databases. Scroll down and you'll see a list of Jobs that can be expanded. Select the job you want to modify and you can control it at that level. / comments
Yes. If you go into the Alerts management window, on the left side of the screen you'll see your servers. You can drill down to an instance and then drill down on the instance. You'll see a list of...
So that's cumulative query time. That database may in fact be the problem. You still don't know that 100% because the query is assigned to the database that calls it, but that query could be calling other databases. It's just this odd point that makes a perfect, "Well, yes, of course that particular database is the one using your CPU resources" difficult to say with certainty. It depends on the queries.
That said, the queries from that database are absolutely the top cost of CPU on your system. We can say that with 100% certainty.
Does that help? / comments
So that's cumulative query time. That database may in fact be the problem. You still don't know that 100% because the query is assigned to the database that calls it, but that query could be callin...