Using MS SQL Server

SqlBulkCopy.WriteToServer() blowing up on tables with Identity columns
I'm using the SqlBulkCopy object to bulk insert large DataTable's into SQL Server. Its working well except tables with IDENTITY columns in them. When calling SqlBulkCopy.WriteToServer(DataTable) - I hit the following error "The given value of type String from the data source cannot be converted to type bigint o... 19 Jun 2008 01:14

SQL 2008 EULA and pricing
Anyone have a link to these? (are they even officially out there yet?) A google search and a search of MS's website revealed nothing. Will SQL 2008 allow "downgrade" licensing like they've done with their OS's? -- Greg Moore SQL Server DBA Consulting Remote and Onsite available! Email: sql ... 19 Jun 2008 01:14

Sifobo Enterprise Manager for SQL Server - Free Download
Dear all, Sifobo Enterprise Manager for Oracle And SQL Server is an MMC based Oracle and SQL database backup manager for Windows and available for free download on http://www.sifobo.com Please feel free to download and use it or pass it onto anyone who might be interested..Remember it is FREE ;-) ... 19 Jun 2008 01:14

Forget about Referential checks??
Hi guys. We have an application. There are 3 (at the moment) different sections, each has access to it's own 'Diary'. A section is like, 'Sub Program', which contains numerous sub programs. Programs, which contains numerous Programs, each with numerous Sub Programs. So, Each Sub Program has numerous Diarty... 19 Jun 2008 01:14

Vaalirahoitus (oli: Re: Irlanti pelastaa Suomen)
Transmutaatiotekniikasta. *Maassamme ydinalalla on tuskin mit��n niin tarkoin TABU:na piretty� systeemi�, kuin mahdollisuus neutraloida edes osin maailman vaarallisimpia ihmiskunnan ydinj�temoskiaan ydinvoimalasaasteista. P�iv�n selv�� on, ett� t�m� olisi mahdollista, koska sotilassektorilla systeemi� on py�ritetty... 19 Jun 2008 01:14

bulk insert in clustered index table
Hi, I have got the following situation please give me some ideas how to solve/work around it. Current situation: Everyday day about 10 million records are processed and bulk inserted in individual tables. Around 20K records are inserted at a time. At the end of the day this table is clustered indexed. The fie... 19 Jun 2008 01:14

DB migration
I just moved a SQL 2000 database to a new server (backup/restore). This server is much beefier with respect to hardware. The problem is that the system doesn't seem to be very fast at all. It seems to be having issues with thread count. For example, I saw some errors like this in my client apps: "The query pro... 19 Jun 2008 01:14

database design
Does it make sense to create an enterprise database design where there is 1 table for people, another for addresses, another for phones...etc. The idea is each dept would contribute to these tables and then have their own database for specific applications. I'm not a database expert but this design seems nice in th... 19 Jun 2008 01:14

Not finding GUID value after migration sql 2005 to 2000
Dear all, I'd like to ask for your advice in the following problem: I've developed a web app using sql 2005. Now that I've migrated the files to the definitive server which is running sql 2000 I'm running into a problem. The root application that I'm hooking into stores (after successful login) a guid value in t... 19 Jun 2008 03:26

Newbie basic questions
Hi, I'm developing some Powershell applications that will need to pull data out of some sort of container. I've been playing around and had some success getting this working with MS Access. But for various I'm keen to explore other options for this database. I'm only going to need at most 12 tables, each with ... 19 Jun 2008 01:14