Using MS SQL Server

Write "Messages" window to a log file?
Is there a way to write the information that appears in the "Messages" window in SQL Server Management Studio to an external log file? I'd like to keep a record of these logs as I run each script once a month and it would be useful to compare run times for each step. We have several places where we insert variati... 7 Aug 2008 18:37

Deduping
Hi Hows it going , I need a Fast way to check for duplicate rows in a single table the identity keys and Primary Keys dont play in this scenario i have like 10 columns Column1 thru column10 as the columns that make it a duplicate row, any help is welcome Thanks ... 27 Aug 2008 18:44

Yellowfin seeks resellers for BI product
By Jenny Eagle , August 6th 2008 02:45PM Business Intelligence developer, Yellowfin, has taken two mature technologies - BI and GIS - and combined them to create its flagship solution, Yellowfin Business Intelligence 4.0. According to CEO Glen Rabie (pictured), Yellowfin is also actively seeking resellers to p... 6 Aug 2008 01:33

load_file and blobs
I cannot update the blobs correctly with mysql. I exported 3 rows from db2 to mysql database. There are blobs in the database. db2 display the 3 rows as db2 'select cast(type_blob as varchar(200)) from ilwdtypes' 1 -----------------------------------------------------------------------------------... 6 Aug 2008 17:59

Using a Trigger to determine when a column was changed
Hi, I'm new to Triggers, so forgive the elementary question. We have a process that saves data from a VB2005 form into a table in MS SQL 2005, and it saves all data whether the user changed the value or not. Is it possible to create a trigger for this table where a log can be written to if a value is updated w... 5 Aug 2008 15:16

Data returned by SQL Server ODBC driver is not correct
I've a query which happily returns a full set of data when run in SQL Studio but when I do the same query using IIS with Classic ASP connected via ODBC's SQL Server driver (not the native one) numbers returned to the record set are filled with 0 and strings are empty exept for a few rows. This is happening in II... 5 Aug 2008 12:10

Only 90MB for SQL Server 2005 on a Windows 2003 64bit 12GB System
Ulf Dingler (u.dingler(a)lasartes.de) writes: I have a Dell Server with Windows 2003 R2 SP2 64bit ,SQL Server 2005 SP2 (also 64Bit) and 12GB Ram. The Problem is, that the SQL Server Process only allocates max 90-100MB. That's why big SQLs run very slow. I checked the setup variables on the managment cons... 4 Aug 2008 17:44

Only 90MB for SQL Server 2005 on a Windows 2003 64bit 12GB System
Hi. I have a Dell Server with Windows 2003 R2 SP2 64bit ,SQL Server 2005 SP2 (also 64Bit) and 12GB Ram. The Problem is, that the SQL Server Process only allocates max 90-100MB. That's why big SQLs run very slow. I checked the setup variables on the managment console and everything seems to be ok. I don't know... 5 Aug 2008 01:56

Finding duplicate records
Hello to all, I have a small or big problem with a customer data base, where during a change of system we might have created duplicate records. This should be easy to find, you might think, but, we are talking about roughly 10000 records or less in a total volume of 1 MIO records or more. I have considered ... 1 Aug 2008 16:06

SQL 2000 DTS tool - 256 char limit?
I'm using the DTS tool (generally called "Import and Export Data", two cogs) to export a table to a text file. However, it seems to be truncating the char(1024), in that it's only outputting the first 256 chars. Is this a limit of the tool, or am I just doing something wrong? It's early and the coffee hasn't kicked... 1 Aug 2008 05:49