Questions tagged [sql-server-2005]
Use this tag for questions specific to the 2005 version of Microsoft's SQL Server.
sql-server-2005
2,311
questions with no upvoted or accepted answers
11
votes
3
answers
24k
views
SSIS 2005 how to resolve the error "input column has lineage id that was not previously used in the data flow task" programmatically
I'm trying to write a program that automatically add columns from the OLE DB Sources in all of the components in a .dtsx file (the target is SSIS 2005). When I process the .dtsx with my program seems ...
8
votes
1
answer
1k
views
Hide relationship from a SQL Server database diagram
I am using SQL Server 2005 database with SQL Server Management Studio.
Is there a way to hide a relationship between two tables in the diagram without actually deleting the relationship from the ...
6
votes
1
answer
4k
views
Any way to get the column causing a com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated
We have a webapp that uses hibernate to persist data to a sql server 2005 instance.
On occasional we get a com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated.
...
5
votes
1
answer
1k
views
Why does SQL Server “Compute Scalar” when I SELECT a persisted computed column?
I have one persisted column based on a XML field, and SQL Server always use "Compute Scalar" when i query this table. Why? is it not persisted?
I suspect I 'm not doing any condition that prevents ...
5
votes
1
answer
1k
views
ALTER COLUMN query taking too much time
I am using Microsoft SQL Server 2005. I have a table tblTest that has a column called DisplayValue. Current data type and length is NVARCHAR(1000). We are trying to change the size of the column using ...
5
votes
1
answer
912
views
CROSS APPLY a FREETEXTTABLE
MS SQL Server 2005: table1 has a full text index. I want to run multiple freetexttable searches against it in a single query, but the two attempts i have fail. any help would be appreciated, thanks! ...
5
votes
0
answers
629
views
TransactionScope works in some places and not in others
Using ASP.NET 3.5, Linq to SQL, SQL Server 2005 on Windows Server 2003. Running VS 2008 on XP SP3 locally.
We need to be able to wrap inserts, updates, and deletes in a transaction. When we first ...
5
votes
2
answers
367
views
Support multiple assemblies on ASP.NET\C# projects
We're developing a ASP.NET application and having some problems with integration with a MS dll (Microsoft.AnalysisServices)?
The original project was linked to the dll which came with SQLServer2005 (...
4
votes
2
answers
6k
views
How to use user defined table type in function for return?
create type mt as table (a int, b int)
Below function works:
create function fn2()
returns @mt table (a int, b int)
as
begin
insert into @mt
Select 1, 2
return
end
Below does not work:
create ...
4
votes
0
answers
1k
views
Remove an orphaned sys.service_queue
I have an orphaned entry in my sys.service_queues table.
When I do
select * from sys.service_queues where name like '%SqlQueryNotificationService-%'
select * from sys.objects where name like '%...
4
votes
1
answer
9k
views
How to use OpenRowSet to insert data into a blank file?
How to use OpenRowSet to insert data into a blank file?
I need to insert into a txt file (say to D:\TDB) some select output (say select * from sys.tables) from the database
INSERT INTO OPENROWSET('...
4
votes
1
answer
2k
views
Should I be avoiding @@Fetch_Status?
After doing some reading it became apparent that multiple procedures can modify the global variable @@Fetch_Status. We have a stored procedure that calls other stored procedures every hour (kind of ...
4
votes
1
answer
8k
views
AppDomain is marked for unload due to memory pressure
On a 32-bit SQL 2005 Enterprise box, I keep getting "AppDomain XX (DB_NAME.dbo[runtime].YY) is marked for unload due to memory pressure".
I have 8GB physical RAM
AWE is set up to use 4.5GB
No -g512 ...
4
votes
1
answer
2k
views
Issue After Converting Table Column From "Text" to Varchar(max)
I had a table called Person with column PersonDescription which was of type "text".
I had issues with updating this column so i ran the script
ALTER TABLE dbo.Person ALTER COLUMN
...
4
votes
4
answers
654
views
Table in SQL Server won't return more than a few thousand rows
Using SQL Server 2005. I was doing some simple queries on a table that has about 200k records. As of today when I got to work, a simple SELECT * FROM executes till it retrieves about 20k rows...then ...