Recent questions tagged ssms

0 votes

456 views

1 answer

ssms - SQL Server Management Studio: Increase number of characters displayed in result set

I have the following scenario: We have stored procedures which compare our developement database to our customer ... Thanks for your help! See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

338 views

1 answer

ssms - SQL Server Management Studio: Import quietly ignoring 99.9% of data

The Problem i'm trying to import data into a table using SQL Server Management Studio's Import Data task. ... was closed after several weeks. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

391 views

1 answer

ssms - SQL Server Management Studio: Import quietly ignoring 99.9% of data

The Problem i'm trying to import data into a table using SQL Server Management Studio's Import Data task. ... was closed after several weeks. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

452 views

1 answer

ssms - What's the difference between SQL Server Management Studio and the Express edition?

I'm using Express currently. What extra features do I get with the full edition? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

397 views

1 answer

ssms - sql server management console doesn't work with multi-byte characters

I'm trying to work out how to use SQL server management studio properly with multi-byte unicode characters. ... any clues very much appreciated See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

455 views

1 answer

ssms - SQL Server Management Studio missing

i just installed sql server 2008 r2 and SQL Server Management Studio. After installation i found that the SQL Server ... idea how to install it? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

413 views

1 answer

ssms - How do I view executed queries within SQL Server Management Studio?

I am new to SQL Server Management Studio and am wondering: is there is a way to see which queries have been run ... 2008 v 10.0.1600.22. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

526 views

1 answer

ssms - Where is SQL Server Management Studio 2012?

I had SQL Server 2008 R2 and Visual Studio 2008 and 2010 on my laptop. I've installed SQL Server 2012 and have ... How can I fix this problem? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

584 views

1 answer

ssms - How do you debug or step through the code in SQL Server Management Studio 18?

SQL Server Management Studio used to have Debug functionality that would allow to step through the code and watch the ... a bug in the code? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

519 views

1 answer

ssms - SQL Server: How to attach / repair a detached / damaged database?

A database server crashed. I was able to get the mdf and the log file and I am trying to mount it on another ... case, how can I attach it? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

533 views

1 answer

ssms - How to generate scripts to recreate table using SQL Server Management Studio [Schema and data]?

I have a table in a local SQL server database. I want to recreate this table in a hosted database. ... SQL Server Management Studio? Thanks. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

515 views

1 answer

ssms - SQL Server Management Studio, how to get execution time down to milliseconds

When I submit a batch (e.g., perform a query) in SSMS, I see the time it took to execute in the ... the section of interest circled in red: See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

409 views

1 answer

ssms - 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 ( ... db, using instances, etc.) See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

375 views

1 answer

ssms - How can I generate an INSERT script for an existing SQL Server table that includes all stored rows?

I'm looking for a way to generate a "Create and insert all rows" script with SQL Management Studio 2008 ... contains all currently stored rows? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

447 views

1 answer

ssms - How can I manage SQL CE databases in SQL Server Management Studio?

I created a SDF (SQL CE) database with Visual Studio 2008 (Add / New Item / Local Database). Is it ... the Visual Studio 2008 database manager? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

461 views

1 answer

ssms - SQL Server (localdb)v11.0 explained

I'm following Code First to an Existing Database tutorial and noticed that it suggested to connect to (localdb) ... about this kind of database? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

404 views

1 answer

ssms - How to remove "Server name" items from history of SQL Server Management Studio

When trying to connect to a server in Management Studio (specifically 2008), there is a field where you enter ... history for each Server name? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

415 views

1 answer

ssms - Changing the CommandTimeout in SQL Management studio

How can I change the CommandTimeout in SQL Management Studio? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags