sql-server Archives - Page 3 of 16

Programming, sql-server

IT Nursery

SQL Server: Filter output of sp_who2

Under SQL Server, is there an easy way to filter the output of sp_who2? Say I wanted to just show rows for a ...

May 30, 2022
0 Comments

Programming, sql-server

IT Nursery

How to see query history in SQL Server Management Studio

Is the query history stored in some log files? If yes, can you tell me how to find their location? If not, can ...

May 29, 2022
0 Comments

Programming, sql-server

IT Nursery

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. I open SQL Server Management Studio. I ...

May 29, 2022
0 Comments

Programming, sql-server

IT Nursery

How do I escape a percentage sign in T-SQL?

This question also has the answer, but it mentions DB2 specifically. How do I search for a string using LIKE that already has ...

May 29, 2022
0 Comments

Programming, sql-server

IT Nursery

How to alter SQL in “Edit Top 200 Rows” in SSMS 2008

In SQL Server 2008 Management Studio, when I right click on a database table and choose “Select Top 100 Rows“, I can then ...

May 28, 2022
0 Comments

Programming, sql-server

IT Nursery

What is the command to truncate a SQL Server log file?

I need to empty an LDF file before sending to a colleague. How do I force SQL Server to truncate the log? 7 ...

May 28, 2022
0 Comments

Programming, sql-server

IT Nursery

SQL Server Index Naming Conventions [closed]

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, ...

May 28, 2022
0 Comments

Programming, sql-server

IT Nursery

Hidden Features of SQL Server

Locked. This question and its answers are locked because the question is off-topic but has historical significance. It is not currently accepting new ...

May 28, 2022
0 Comments

Programming, sql-server

IT Nursery

How to change column datatype in SQL Server database without losing data?

I have SQL Server database and I just realized that I can change the type of one of the columns from int to ...

May 27, 2022
0 Comments

Programming, sql-server

IT Nursery

Import / Export database with SQL Server Server Management Studio

I thought this would be trivial, but it isn’t… I’m sure there is a simple way to do it but I can’t manage ...

May 27, 2022
0 Comments