sql-server-2005

Alternative TSQL

Hi there This query works well as you can see I have to put split between between @SearchCriteria and the rest of the query due to it's varchar. If I forced, the syntax works well BUT it return nothing when you query possible because extra ' Can you help? ALTER PROCEDURE [dbo].[sp_rte_GetRateList] ( @TenantID INT, @Cu...

Changing column constraint null/not null = rowguid replication error

I have a database running under Sql server 2005 with merge replication. I want to change some of the FK columns to be 'not null' as they should always have a value. SQL server won't let me do that though, this is what it says: Unable to modify table. It is invalid to drop the default constraint on the rowguid column that is us...

SSIS install as part of SQL Developer x86 installation?

I get the following error when trying to install SQL Server 2005 x86 Developer edition in the XP mode in windows 7 Professional. MainEngineThread is returning 1645 Any thoughts/ideas would be appreciated. ...

Error upon connection attempt to SQL Server 2005 via SSMS

I was able to install SQL 2005 x86 dev edition onto windows 7 Professional but cannot connect to the server via SSMS. I get "Login Failed for user 'Compaq\username'. (Microsoft SQL Server, Error: 18456)" Any suggestions ...

cannot login to database

Cannot open database "Architect" requested by the login. The login failed. Login failed for user 'Local System Name\ASPNET'. <add name="ArchitectConnectionString" connectionString="Data Source=192.168.1.15,1433; Network Library=DBMSSOCN;Initial Catalog=Architect; Integrated ...

How we can use CTE in subquery in sql server?

How we can use CTE in subquery in sql server? like .. select id (i want to use CTE here), name from table_name ...

LINQ to SQL: First call

I'm using LINQ to SQL to access the database (SQL Server 2005). The first call takes up to 10 seconds to retrieve the data, a second call takes less than a second. What can be done to improve the performance of the first call to the database? The database action happens in the controller of a asp.net mvc application. Thanks ...

Chaning varchar Meridiem Time to Twenty Four Hour time in Sql

I have this type of data TimeOFDay column is varchar. I want to change this time in 24 hour time, using SQL, and updating TwentyFourHourTime column. TwentyFourHourTime column is also varchar. How can I do this. Thanks. ...

DTSX file recovery

To begin with, I know very little about DTSX files and SSIS, but my boss wanted another pair of eyes looking at this problem. Apparently there were some problems running nightly jobs. From what I've been told, the DTSX files being used had to be recovered with an undelete tool and apparently that wasn't successful. We now have some DTSX...

Does SET NOCOUNT ON really make that much of a performance difference

In this article, the author suggests that there is material overhead associated with SET NOCOUNT ON and that "By removing this extra overhead from the network it can greatly improve overall performance for your database and application" The author references a change in the default stored procedure template from 2000 to 2005 and suggest...

Is writing a query using Views a good strategy?

I just want to know whether it is correct to write a query by first creating it in a view. Any suggestions? ...

How can I copy data records between two instances of an SQLServer database

I need to programmatically (ADO.Net) copy records from a table in one database to a table in another database on a different server. This is very similar to "How can I copy data records between two instances of an SQLServer database" except that I am not allowed to create a link to the destination server so the accepted answer to that qu...

Getting connectivity error when using :connect command in sqlcmd, but not when doing command line connect

I'm just starting out with sqlcmd on SQL Server 2005, enterprise edition. I can connect to my server fine, from the command line: sqlcmd -SSQLSERVERNAME -Q"select test=1" However, when I create a junk.sql file that has just this one line: :connect -SSQLSERVERNAME ...and try to run it by running the following at the command line: ...

Is there a rendering provider for SSRS and Adobe Indesign

As a faint hope, does anyone know of an integration piece for SQL Server Reporting Services, such that we could use our Adobe Indesign templates? ...

How do you query for comments stackoverflow style?

I saw this question on meta: http://meta.stackoverflow.com/questions/33101/how-does-so-query-comments I wanted to set the record straight and ask the question in a proper technical way. Say I have 2 tables: Posts id content parent_id (null for questions, question_id for answer) Comments id body is_deleted post...

DROP INDEX never finishes...

I'm trying to drop an index that I have but when I execute the statement it just runs and runs (up to 30 mins before i stopped it last time). Has anyone ever run into this before? Any suggestions on how to free it up for deletion? ...

SQL: Select distinct values from 1 column

I want to select distinct values from only one column (the BoekingPlaatsId column) with this query: SELECT MAX(BoekingPlaatsId), BewonerId, Naam, VoorNaam FROM table GROUP BY BewonerId, Naam, VoorNaam How do I do that in SQL Server? ...

SQL Server / Link Server SOTAMAS90 ?

Can anyone tell me how to create a link server in SQL Server 2005 with SOTAMAS90? ...

How to create a column of a specific type ?

How would I add a column to a Select and have that column be of a specific type. For example Select Company, City, Dues, 0 As NewColumn1, 123.12 As NewColumn2 But I want NewColumn1 to be of type bit, and NewColumn2 to be of type Real Oh, I'm using SQL Server 2005. ...

Sql Server datetime conversion

Hi all I am trying to convert varchar date value to datetime format. Showing error select CONVERT(DATETIME, Convert(varchar, 20/12/2009, 103 ),103) error: Conversion failed when converting datetime from character string. Geetha ...