Tag: sql-server-2005

How do I make this transaction safe in a concurrent environment? (SQL Server 2005)

Suppose I have these two tables: Invoice ——- iInvoiceID int PK not null dtCompleted datetime null InvoiceItem ———– iInvoiceItemID int PK not null iInvoiceID int FK (Invoice.iInvoiceID) not null dtCompleted datetime null Each InvoiceItem might be fulfilled by a different process (executable) that runs on a different machine. When the process is complete, I want […]

Records not replicated when inserted by custom replication stored procedure

I’ve just recently setup a custom replication for my subscriber database, as described in another post here. Basically, when the publisher pushes a new record to the subscribers, the stored procedure will also insert a replicated time into an extra column in the table, and insert a new record to a log table. My problem […]

List of DatabaseVersion values from RESTORE HEADERLISTONLY?

Is there a published list of expected values by SQL Server version that match to the DatabaseVersion column returned by a RESTORE HEADERLISTONLY command? For example, DatabaseVersion 611 = SQL 2005 SP_ ? Plenty of references for SQL Server build numbers to product versions (ex. SQL Server 2005 SP3 = 9.0.4035), my Google and Bing […]

Date Format conversion in SQL

I want to convert date format from 01/09 to January 2009 , 09/03 to September 2003 etc. Is this possible in SQL? Please let me know if there is a API for the same.

XML and Sql Server 2005

i have a problem that I want to resolve in a best possible way. The thing is that I made a schema that looks like this: print(” <xs:complexType name=”rentACarT”> <xs:sequence> <xs:element name=”poslovnice” type=”poslovniceT” /> <xs:element name=”korisnici” type=”korisniciT” /> </xs:sequence> </xs:complexType> <xs:complexType name=”poslovniceT”> <xs:sequence> <xs:element name=”poslovnica” type=”poslovnicaT” minOccurs=”0″ maxOccurs=”unbounded” /> </xs:sequence> </xs:complexType> <xs:complexType name=”poslovnicaT”> <xs:sequence> <xs:element […]

Remote SP Call via Linked Servers. Asynchronous or not?

I have set up 2 servers which are linked. From my LOCAL SERVER, I am executing a SP that will be run on the REMOTE SERVER. The next part of the script requires me to INSERT DATA from the changes made via the SP on the REMOTE SERVER to the LOCAL SERVER. Therefore my question […]

SQL Server Provisioning Tool

Running under Server 2008, SQL Server 2005 SP2 has the option to “Add New Administrator” from the SQL Server 2005 Surface Ara Configuration. This launches the SQL Server 2005 User Provisioning Tool for Vista. You are then able to grant privileges such as Server SysAdmin role etc. When I do this the privileges are copied […]

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?

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