I have a SQL Server 2000 dts package which copies data from a DBF file to SQL Table I have created a System DSN and provided UNC Names for both Connection and开发者_高级运维 Database file itself.
I have 开发者_如何学编程data like this: IDNameDate 1kishore18-jan-2010 2kishh19-jan-2010 3kiiNULL
I am using NHibernate 3. My application works fine when run against SQL Server 2008 but has intermittent errors on SQL 2000 (we\'ve changed the NH dialect appropriately). The errors are all related to
I have a very meaty stored procedure in a SQL Server 2000 DB which returns a single resultset. I don\'t want to (not allowed to) touch the original SP but would like add pagination to the returned rec
I\'ve got a table of invoices and a child table of related data related by key.In particular, for each invoice, I\'m interested in only the first related row from the child table.Given that I want the
I would like to ask help regarding this error. Here are the details regarding this error. Step Error Source: Microsoft Data Transformation Services (DTS) Data Pump
I know how to add the description through the server management studio. And i came across some EXEC thing someplace that looked overly complex to add a field description.
I asked a nearly identical question and got a valid working answer: Previous Question There is a minor change here that makes the answer in that question not work in a special case in my database. I
How would I create a Custom Trigger or Computed Column that works similar to an Identity? I have two fields that need to be auto-incremented but in a particular order: ID and REV.
recently been moving a legacy database in SQL Server 2000 to SQL Server 2005. I did following things: Restore SQL 2000 DB on SQL 2005 serv开发者_如何转开发er
加载中,请稍侯......