Alex Rivera | Logout

Questions tagged sql-server-2005

288 questions · page 4 of 6

Sort by: Newest Votes Active
19
votes
6
answers

Is there a SVN plugin for SQL Server Management Studio 2005 or 2008?

sql-server sql-server-2005 svn sql-server-2008 tortoisesvn
asked 2009-11-11T16:30:23.587
50
votes
3
answers

Get all child records given a parent id in a self referencing table

sql sql-server-2005 recursion hierarchy
asked 2009-11-06T09:04:04.597
10
votes
1
answers

Connection pool setting of SQL Server connection string

c# asp.net sql-server-2005 ado.net .net-2.0
asked 2009-10-29T16:53:19.660
52
votes
6
answers

How to insert a blob into a database using sql server management studio

sql sql-server sql-server-2005 blob
asked 2009-10-29T13:12:38.270
19
votes
5
answers

How to notify a windows service(c#) of a DB Table Change(sql 2005)?

c# sql-server-2005 triggers sqlclr
asked 2009-10-13T11:13:37.357
33
votes
5
answers

How can I use if statement after a CTE (SQL Server 2005)

sql sql-server sql-server-2005 t-sql common-table-expression
asked 2009-10-13T03:42:43.143
464
votes
15
answers

How to SELECT FROM stored procedure

sql sql-server sql-server-2005 stored-procedures
asked 2009-09-29T13:05:57.613
92
votes
4
answers

How can I convert ticks to a date format?

c# asp.net sql-server sql-server-2005
asked 2009-09-28T20:40:53.747
64
votes
18
answers

Generate a resultset of incrementing dates in T-SQL

sql sql-server database sql-server-2005 t-sql
asked 2009-09-25T18:42:00.773
34
votes
6
answers

Sql Server : How to use an aggregate function like MAX in a WHERE clause

sql sql-server sql-server-2005 t-sql aggregate
asked 2009-09-25T05:39:01.323
41
votes
7
answers

Changing INT to BigInt

sql sql-server-2005
asked 2009-09-22T20:18:26.713
13
votes
6
answers

Access sometimes jumps to existing record on save new record - Access2k FE/SQL2005 BE

sql database sql-server-2005 ms-access vba
asked 2009-09-15T05:14:07.807
18
votes
3
answers

foreign keys on table from different database

sql sql-server sql-server-2005 t-sql
asked 2009-09-14T23:07:14.113
132
votes
12
answers

Datatype for storing ip address in SQL Server

sql-server t-sql sql-server-2005 types ip-address
asked 2009-09-06T12:22:39.567
18
votes
3
answers

For Nvarchar(Max) I am only getting 4000 characters in TSQL?

sql sql-server sql-server-2005 t-sql nvarchar
asked 2009-09-03T04:04:02.580
9
votes
3
answers

Get Updated Row

sql sql-server sql-server-2005 t-sql
asked 2009-09-02T10:59:38.877
30
votes
3
answers

SQL Server Check/NoCheck difference in generated scripts

sql-server sql-server-2005
asked 2009-08-26T22:49:26.127
60
votes
5
answers

Create a one to many relationship using SQL Server

sql sql-server sql-server-2005
asked 2009-08-20T19:31:30.037
37
votes
3
answers

XML query() works, value() requires singleton found xdt:untypedAtomic

sql sql-server sql-server-2005 t-sql xquery
asked 2009-08-19T19:15:52.920
57
votes
5
answers

Can I save an 'Object' in a SQL Server database?

c# sql-server sql-server-2005 ado.net
asked 2009-08-19T11:45:49.750
38
votes
10
answers

SSIS Connection Manager Not Storing SQL Password

sql-server sql-server-2005 ssis
asked 2009-08-13T19:27:08.357
39
votes
12
answers

SP taking 15 minutes, but the same query when executed returns results in 1-2 minutes

sql sql-server stored-procedures sql-server-2005 parameter-sniffing
asked 2009-08-12T09:52:33.213
24
votes
5
answers

Update function in TSQL trigger

sql sql-server sql-server-2005 t-sql
asked 2009-08-08T14:43:19.373
23
votes
3
answers

What does Trusted = yes/no mean in Sql connection string?

c# sql-server-2005 ado.net
asked 2009-08-07T05:11:20.987
10
votes
2
answers

Error Handling in User Defined Functions

sql-server sql-server-2005 function error-handling user-defined-functions
asked 2009-08-06T18:11:48.403
70
votes
5
answers

How get the T-SQL code to find duplicates?

sql-server-2005 t-sql ssms
asked 2009-08-03T14:12:05.863
11
votes
3
answers

How to sort the result set of an UPDATE statement that uses the OUTPUT clause?

sql-server t-sql sql-server-2005
asked 2009-07-31T15:27:53.157
71
votes
5
answers

SQL GROUP BY CASE statement with aggregate function

sql sql-server sql-server-2005 group-by
asked 2009-07-30T19:38:28.930
19
votes
3
answers

How to get the Index Name from IndexId in SQL Server 2005

sql-server sql-server-2005
asked 2009-07-24T17:49:06.143
54
votes
16
answers

SQL Server error on update command - "A severe error occurred on the current command"

sql-server sql-server-2005 t-sql
asked 2009-07-24T00:34:13.660
17
votes
5
answers

Installation of SQL Server Business Intelligence Development Studio

sql-server sql-server-2005 business-intelligence bids
asked 2009-07-19T16:04:59.197
75
votes
5
answers

How can I create a SQL unique constraint based on 2 columns?

sql-server sql-server-2005 sql-server-2008 constraints unique-constraint
asked 2009-07-10T13:44:47.287
23
votes
2
answers

How to filter SQL Server 2008 Profiler Output for a single database?

sql-server sql-server-2005 sql-server-2008 sql-server-profiler
asked 2009-07-03T14:39:10.697
11
votes
5
answers

LINQ to SQL entity column name attribute ignored with guid primary key

c# sql-server linq sql-server-2005 linq-to-sql
asked 2009-07-01T04:29:38.510
16
votes
1
answers

FOR XML PATH(''): Escaping "special" characters

sql-server t-sql sql-server-2005 for-xml-path
asked 2009-06-26T21:30:40.157
44
votes
6
answers

Transaction Isolation Level Scopes

sql-server t-sql sql-server-2005 isolation-level
asked 2009-06-25T19:01:06.493
31
votes
5
answers

Efficient way of getting @@rowcount from a query using row_number

sql sql-server t-sql sql-server-2005
asked 2009-06-24T13:49:39.223
12
votes
5
answers

What is a stored procedure with a padlock icon in SQL Server 2005?

stored-procedures sql-server-2005 locking
asked 2009-06-22T14:29:03.150
34
votes
12
answers

IN vs. JOIN with large rowsets

sql sql-server-2005 performance join
asked 2009-06-16T13:39:20.037
42
votes
3
answers

How do I increase the maximum allowed attachment size for email sent using msdb.dbo.sp_send_dbmail in Microsoft SQL Server 2005/2008

sql-server sql-server-2005 sql-server-2008
asked 2009-06-15T18:37:12.537
168
votes
7
answers

Can I create a One-Time-Use Function in a Script or Stored Procedure?

sql sql-server sql-server-2005 t-sql scripting
asked 2009-06-11T14:30:32.600
46
votes
7
answers

How to check that there is transaction that is not yet committed in SQL Server 2005?

sql sql-server sql-server-2005 transactions
asked 2009-06-11T09:22:39.883
11
votes
1
answers

How to create a file system directory in a SQL Server 2005 call/query

sql sql-server-2005
asked 2009-06-11T00:32:20.147
9
votes
4
answers

In SQL server is there any way to get the 'use database' command to accept a variable

sql-server sql-server-2005 scripting
asked 2009-06-09T09:23:22.990
10
votes
3
answers

Database Replication or Mirroring?

sql-server-2005 replication
asked 2009-05-29T03:24:12.310
272
votes
14
answers

How can a LEFT OUTER JOIN return more records than exist in the left table?

sql sql-server sql-server-2005 t-sql
asked 2009-05-27T15:30:11.440
30
votes
2
answers

SQL Server 2005 Computed Column Is Persisted

sql-server-2005 calculated-columns
asked 2009-05-27T14:37:59.173
28
votes
5
answers

Specific Time Range Query in SQL Server

sql-server-2005 datetime
asked 2009-05-19T21:43:22.377
49
votes
2
answers

A way to check if foreign key exists in SQL 2005

sql sql-server-2005 foreign-keys
asked 2009-05-15T14:35:57.117
47
votes
6
answers

Linking ALL Users to Login after restoring a SQL Server 2005 database

sql-server t-sql sql-server-2005
asked 2009-05-15T10:45:09.527
← Prev page 4 of 6 Next →