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 […]
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 […]
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 […]
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.
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 […]
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 […]
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 […]
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 […]
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 […]
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?