ssms
How in SQL Server Management Studio 2008 to rollback easily?
I\'m used to setting Oracle\'s tools to not auto-commit, run statements, then click a \'rollback\' button if I\'m not happy with the result. I\'m hoping I\'m overlooking something in开发者_开发知识库[详细]
2023-04-07 19:32 分类:问答SQL Azure: SMO Exception when scripting objects in SSMS 2008 R2
I am using SQL Server Management Studio 2008 R2 to manage a SQL Azure database.When I try to right-click on any of the objects in the database, and do 开发者_运维问答Script Table As -> CREATE -> New Q[详细]
2023-04-07 00:41 分类:问答How did my SQL Server 2008 trigger get deleted?
This is a very strange problem. I\'ve asked about it before here: How did my trigger get deleted? I renamed my trigger and I thought it had stopped happening but the problem seems to have come back ag[详细]
2023-04-06 18:56 分类:问答Creating a user without an associated login is not supported in SQL Server 2008 R2
When scripting a SQL Server 2000 database, on an SQL Server 2000 version of SQL Server, with SQL Server Management Studio 2008 R2 (10.50.1617.0) i get the error:[详细]
2023-04-06 13:00 分类:问答Refreshing a database or table with management tools
In SQL Server Management Studio there is an option to refresh a table / database? Is there a similar option for Oracle? If yes how do I do this? Is there a command to run to do this? Lastly what does[详细]
2023-04-05 15:45 分类:问答SQL Server Management Studio won't work after Windows Update
Came to work this morning, my PC (Win7 x64) had force rebooted by Windows Update. Now, SQL Server Management Studio (SQL Server 2008 r2) fails when connecting to a database and trying to expand the tr[详细]
2023-04-05 12:18 分类:问答What could cause SSMS to not parse SQL properly? [closed]
This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time,or an extraordinarily narrow situation that is not generally applic[详细]
2023-04-05 11:19 分类:问答SSMS intermittently executes my highlighted script against the wrong database
On SQL Server 2008 R开发者_开发知识库2, I have a script that explicitly begins with USE MyDatabase;[详细]
2023-04-05 04:19 分类:问答Query designer in SSMS and order of join sequence?
SSMS has a query designer, which I usually avoid, because honestly, I can\'t really work with it. Unfortunately, my colleagues do.[详细]
2023-04-03 18:07 分类:问答SQL Server 2008 - Double Click to open table? [duplicate]
This question already has answers here: Why isn't my SQL query to insert a table row working properly?[详细]
2023-04-03 01:51 分类:问答