Tag: sql-server-2005

Row Col Transposition in SQL Server 2005/2000

In SQL Server 2005, I have a table say tbl_Info. There I have one column say Info. The values are as under Name1 Age1 Sex1 Name2 Age2 Sex2 ….. ….. ….. And the row values goes on like this. My question is how to make row col transposition. The desired output will be Name Age […]

debug ssis package – reload InnerPackage.dtsx

I used the wizard to build a package that loops through my tables does whatever. It has worked forever and now I have to change it. How on earth do I debug this thing? When I try to run it from bids, it opens InnerPackage.dtsx for editing and then asks me if I want to […]

Move/copy SQL Server 2005 full text index

We are moving our database server to a bigger box. I have several databases with full text indexes. What is the best way to move the full text indexes?

Finding complement date ranges?

I have two tables both of which have columns StartDate and EndDate. I’m trying to return a single resultset that contains all date ranges from one table (TableA), and all complement date ranges from the other one (TableB). CREATE TABLE [dbo].[TableA]( [ID] [int] NOT NULL, [StartDate] [datetime] NOT NULL, [EndDate] [datetime] NOT NULL ) CREATE […]

How to extract relational data from XML in SQL Server

I’m new to XML world. I’m having a problem with XML data type in SQL Server 2005. I’ve a stored procedure that expects XML parameter. The value of the parameter as given below… DECLARE @productIds xml SET @productIds = ‘<ROOT> <AGENTLIST> <AGENT> <HOSTAPPLICATIONRECORDKEY>GRI</HOSTAPPLICATIONRECORDKEY> <BROKERID>02h21a0539</BROKERID> <BROKERSHARE>25</BROKERSHARE> <BROKERSTATE>AK</BROKERSTATE> <CARRIERCODE>GRIC</CARRIERCODE> <PLANCODE>EP02</PLANCODE> <COVERAGECODES> <COVERAGECODE>TL50IM06</COVERAGECODE> <COVERAGECODE>TL50IM10</COVERAGECODE> </COVERAGECODES> <SPLITBROKERID1>2</SPLITBROKERID1> <SPLITBROKERSHARE1>25</SPLITBROKERSHARE1> <SPLITBROKERID2></SPLITBROKERID2> […]

SQL Server 2005 64bit query blocking

We are experiencing some difficulties with SQL Server performance and wanted some help. Our environment is: – Windows 2003 Enterprise x64 Edition R2 Intel E5450 Quad Core 3ghz Processor 16GB RAM SQL Server 2005 64bit Enterprise Edition (9.00.3282.00) Database compatibility is 8 (but tested on 9 as well) Hyperthreading is switched off We have one […]

copy Ms access single Big Table to Sql server two small tables

I have single big table in Ms access 2k daabase and i need a way to copy this table and then populate my two already ready tables on sql server . I can use Migration tool but is there any way we can do it from Ms access like a form which executes the stored […]

WPF SQL Distributed Data Model with LINQ and SQL Express

I am developing an application in C#/WPF that requires a distributed data model, as it will have both online and offline access. My current thoughts are to develop the first version of the application against SQL Server express and LINQ to SQL. Then use the schema to create a SQL Express Compact DB (and modify […]

Security for requesting temporary logins

I need to set up a system which will allow developers to request an emergency ID for a database. They will be assigned to a role called ‘analyst’ which will provide them a drop down box with the databases they can gain access to. They will submit the request and a temporary SQL Login will […]

Blank screen when looking at Activity Monitor details

I’m looking at the Activity Monitor in SQL Server 2005 and when I double click a specific process to view the SQL I am given a blank screen. What does this mean? What could be causing this?

MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.