tagged [ssms]
How to connect to LocalDb
How to connect to LocalDb I installed LocalDb using the SqlLocalDb.msi package and I can connect to it using SSMS using the server name `(LocalDb)\v11.0`. So far so good. The problem is that when I tr...
How to quickly edit values in table in SQL Server Management Studio?
How to quickly edit values in table in SQL Server Management Studio? Aside from context menu -> "Edit Top 200 Rows" from Object Explorer, is there a quick way to open a table in Edit mode where I can ...
- Modified
- 8 Oct at 03:30
How do I grant myself admin access to a local SQL Server instance?
How do I grant myself admin access to a local SQL Server instance? I installed SQL Server 2008 R2 to my local machine. But, I can't create a new database because of rights (or lack of). > "CREATE DATA...
- Modified
- 14 May at 07:11
How to change default database in SQL Server without using MS SQL Server Management Studio?
How to change default database in SQL Server without using MS SQL Server Management Studio? I dropped a database from SQL Server, however it turns out that was set to use the dropped database as its d...
- Modified
- 15 Sep at 20:1
Import / Export database with SQL Server Server Management Studio
Import / Export database with SQL Server Server Management Studio I want to import/export the database itself, the tables, the constraints (foreign keys and so on). I'd rather not get the data with it...
- Modified
- 17 Jul at 12:11
SQL query, if value is null then return 1
SQL query, if value is null then return 1 I have a query that is returning the exchange rate value set up in our system. Not every order will have an exchange rate (currate.currentrate) so it is retur...
Grid control in SSMS
Grid control in SSMS I notice in (SQL Server Management Studio 2016), the query results return within a blink of a second (above 10k+ rows). The result table/grid scroll perfectly smooth, and have an ...
- Modified
- 28 Oct at 04:28
SQL Server 2008 can't login with newly created user
SQL Server 2008 can't login with newly created user I'm using using Windows Vista and I'm having trouble logging in with a newly created user. 1. I open SQL Server Management Studio. 2. I create a new...
- Modified
- 15 Apr at 22:25
sql server invalid object name - but tables are listed in SSMS tables list
sql server invalid object name - but tables are listed in SSMS tables list I am attempting to create a `Stored Procedure` for a newly created database. However the `SSMS` intellisense does not recogni...
- Modified
- 28 Mar at 11:26
Stop Monitoring SQL Services for Registered Servers in SMSS
Stop Monitoring SQL Services for Registered Servers in SMSS Question: Is it possible to stop SSMS from monitoring the service status of registered servers? Details: SSMS 2008 monitors the service stat...
- Modified
- 23 Jul at 03:16
How do I grant read access for a user to a database in SQL Server?
How do I grant read access for a user to a database in SQL Server? I want to grant access to a user to a specific database with read and write access. The user is already available in the domain but n...
- Modified
- 8 Jun at 08:9
What is the T-SQL syntax to connect to another SQL Server?
What is the T-SQL syntax to connect to another SQL Server? If I need to copy a stored procedure (SP) from one SQL Server to another I right click on the SP in SSMS and select Script Stored Procedure a...
- Modified
- 12 May at 13:33
What is the best way to auto-generate INSERT statements for a SQL Server table?
What is the best way to auto-generate INSERT statements for a SQL Server table? We are writing a new application, and while testing, we will need a bunch of dummy data. I've added that data by using M...
- Modified
- 22 Jul at 21:43
How do I view the full content of a text or varchar(MAX) column in SQL Server 2008 Management Studio?
How do I view the full content of a text or varchar(MAX) column in SQL Server 2008 Management Studio? In this live SQL Server 2008 (build 10.0.1600) database, there's an `Events` table, which contains...
- Modified
- 3 May at 17:29