Questions tagged [sql-server-2005]

488

votes

19

answers

How to avoid the "divide by zero" error in SQL?

asked 2009-05-14T06:06:05.087

9

votes

3

answers

Grant user insert permission after create table command

sql-server-2005 t-sql

asked 2009-05-11T21:22:58.993

9

votes

6

answers

Finding out which locks that are acquired in a query on SQL Server?

sql sql-server sql-server-2005 t-sql

asked 2009-05-07T12:13:42.717

22

votes

5

answers

SQLCMD, command-line variables and script :setvar

sql-server sql-server-2005 sqlcmd

asked 2009-05-07T09:26:36.347

11

votes

2

answers

Best way to get PK Guid of inserted row

sql-server sql-server-2005 insert identity uniqueidentifier

asked 2009-05-01T09:53:13.523

17

votes

3

answers

How to make a column case sensitive in sql 2005 or 2008

sql sql-server sql-server-2005 sql-server-2008

asked 2009-04-30T06:44:25.813

9

votes

3

answers

What does "%%DatabaseEx" do in TSQL?

sql sql-server sql-server-2005 t-sql stored-procedures

asked 2009-04-29T13:04:46.030

16

votes

8

answers

Why do SQL Server Scalar-valued functions get slower?

sql sql-server t-sql sql-server-2005 sql-function

asked 2009-04-28T22:01:43.377

394

votes

9

answers

How to get first character of a string in SQL?

sql sql-server sql-server-2005

asked 2009-04-27T05:02:48.170

15

votes

8

answers

How to recover database from MDF in SQL Server 2005?

sql-server sql-server-2005 mdf data-recovery

asked 2009-04-21T15:07:31.603

70

votes

4

answers

How do I change the owner of a SQL Server database?

sql-server sql-server-2005 permissions

asked 2009-04-20T18:13:40.790

162

votes

13

answers

How to change identity column values programmatically?

sql-server sql-server-2005 t-sql identity sql-server-2005-express

asked 2009-04-15T12:43:47.930

24

votes

2

answers

How do you call a Stored Procedure in SSIS?

sql-server sql-server-2005 stored-procedures ssis parameters

asked 2009-04-13T20:13:46.197

12

votes

4

answers

Problem using SQL Agent to run SSIS Packages - fails with "DTSER_FAILURE(1)"

sql-server sql-server-2005 ssis sql-server-agent

asked 2009-04-09T08:37:43.837

27

votes

4

answers

SQL server profiler not showing LINQ To Sql queries

sql sql-server sql-server-2005 linq-to-sql sql-server-profiler

asked 2009-04-08T12:41:51.543

11

votes

8

answers

Reporting Services - hide table column based upon report parameter

sql-server-2005 reporting-services parameters

asked 2009-04-07T17:28:19.850

52

votes

8

answers

SQL server identity column values start at 0 instead of 1

sql sql-server sql-server-2005 identity auto-increment

asked 2009-04-07T08:38:21.827

11

votes

6

answers

SQL query to exclude records if it matches an entry in another table (such as holiday dates)

sql join sql-server-2005

asked 2009-04-02T21:09:30.203

20

votes

15

answers

SQL 'ORDER BY' slowness

database sql-server-2005

asked 2009-04-01T20:03:07.010

12

votes

4

answers

Update autoincrement column in SQL server

sql-server-2005

asked 2009-03-27T18:05:12.557

9

votes

11

answers

Evaluate in T-SQL

sql-server-2005 t-sql evaluation

asked 2009-03-27T03:27:04.290

45

votes

9

answers

How can I find Unicode/non-ASCII characters in an NTEXT field in a SQL Server 2005 table?

sql sql-server sql-server-2005

asked 2009-03-26T18:15:27.177

10

votes

5

answers

How to Find the list of Stored Procedures which affect a particular column?

sql sql-server sql-server-2005 stored-procedures

asked 2009-03-26T15:21:30.790

11

votes

10

answers

Very large tables in SQL Server

sql-server sql-server-2005

asked 2009-03-24T13:50:28.683

22

votes

19

answers

Not connecting to SQL Server over VPN

sql-server-2005 vpn

asked 2009-03-21T14:22:34.623

43

votes

5

answers

SQL Server deadlocks between select/update or multiple selects

sql-server sql-server-2005 deadlock

asked 2009-03-19T11:48:37.437

20

votes

7

answers

How to get Windows Log-in User Name for a SQL Log in User

sql sql-server windows sql-server-2005

asked 2009-03-15T17:14:07.117

23

votes

5

answers

Performance questions for SQL Cache Dependency

sql sql-server-2005 sql-server-2008 sqlcachedependency

asked 2009-03-13T14:00:07.447

67

votes

8

answers

How to get difference between two rows for a column field?

sql sql-server t-sql sql-server-2005

asked 2009-03-11T13:43:53.350

11

votes

5

answers

SQL Server 2005 Memory Pressure and tempdb writes problem

sql-server sql-server-2005 performance tempdb

asked 2009-03-06T20:05:37.593

32

votes

2

answers

Find Locked Table in SQL Server

sql-server sql-server-2008 sql-server-2005 sql-server-2012 sql-server-2008-r2

asked 2009-03-01T07:51:35.870

79

votes

15

answers

Search for a string in all tables, rows and columns of a DB

sql sql-server-2005

asked 2009-02-26T18:35:34.897

202

votes

11

answers

Equivalent of a COUNTIF aggregate function

sql sql-server-2005

asked 2009-02-24T17:17:19.047

90

votes

4

answers

Watching variables in SSIS during debug

sql sql-server-2005 debugging ssis watch

asked 2009-02-24T15:23:22.287

32

votes

12

answers

Useful system stored procedures in SQL Server

sql sql-server sql-server-2005 stored-procedures

asked 2009-02-23T17:09:22.570

18

votes

6

answers

Make SQL Server faster at manipulating data - turn off transaction logging?

sql-server sql-server-2005

asked 2009-02-21T00:18:15.417

22

votes

6

answers

SQL Server: How do I add a constraint to an existing table but only if the constraint does not already exist?

sql-server sql-server-2005

asked 2009-02-13T18:16:30.817

26

votes

8

answers

Is it possible to restore Sql Server 2008 backup in sql server 2005

sql sql-server-2005 sql-server-2008

asked 2009-02-13T09:26:27.597

11

votes

7

answers

Get just the Date from grouping in select from DateTime column in SQL Server

sql-server sql-server-2005

asked 2009-02-12T19:04:06.933

48

votes

2

answers

Set a existing column of MS SQL table as NOT NULL

sql-server sql-server-2005

asked 2009-02-11T09:27:30.840

13

votes

25

answers

What is your biggest SQL Server mistake or embarrassing incident?

sql-server sql-server-2005 t-sql

asked 2009-02-09T14:03:17.737

18

votes

3

answers

How can I fire a trigger BEFORE a delete in T-SQL 2005?

sql sql-server-2005 t-sql

asked 2009-02-05T14:28:48.903

108

votes

3

answers

MultipleActiveResultSets=True or multiple connections?

c# .net sql-server sql-server-2005 ado.net

asked 2009-02-04T11:05:42.810

22

votes

11

answers

Can we write a sub function or procedure inside another stored procedure

sql sql-server-2005

asked 2009-01-30T14:37:41.310

10

votes

5

answers

SQL Server, Converting NTEXT to NVARCHAR(MAX)

sql sql-server sql-server-2005

asked 2009-01-28T11:36:29.840

121

votes

10

answers

SQL Server - where is "sys.functions"?

sql sql-server sql-server-2005 stored-functions

asked 2009-01-22T10:56:08.700

15

votes

2

answers

cyrillic search

sql-server t-sql sql-server-2005

asked 2009-01-21T20:03:05.320

31

votes

3

answers

How to use LIMIT keyword in SQL Server 2005?

sql sql-server sql-server-2005 limit

asked 2009-01-18T11:44:28.737

18

votes

14

answers

No Process Is on the Other End of the Pipe

sql-server sql-server-2005 ssis

asked 2009-01-16T19:51:49.877

16

votes

3

answers

SQL Server 2005: Determine datatype of variable

sql sql-server-2005 t-sql

asked 2009-01-15T18:43:08.617

Questions tagged sql-server-2005