milliseconds in datetime variable.
	Hi, I am wondering how to compare 2 datetime values so that milliseconds are taken into account. as an example I have the following script. it appears that if I compare two datetime variables then milliseconds are not taken into account, however if I compare two datatime2 variables then milliseconds are taken into account.... more » By Martin  - 06:41 - 3 new of 3 messages

	creating table on secondery filegroup
	hello there i have database with two filegroups and for each filegroup there is diffrent file name How can I use Select .. into and create new table on secondery filegroup? By Roy Goldhammer  - 8 Nov - 4 new of 4 messages

	Sql Server on VMWare
	Hi, Can anybody give me some right direction or usefull link 1. About VMware environment 2. How to Install and configure Sql Server 2005 on VMware. 3. Is there any performance change on VMware. Regards Rahul By Rahul  - 8 Nov - 3 new of 3 messages

	Free Tools for SQL Server - SQLsoft.co.uk
	Hi All, We've written a number of (I think!) handy tools over the past few months which are available from here: [link] Newly released is SQLscripta, which both searches _and_ scripts sprocs, functions, views and triggers, with searches being performed across multiple databases - it's quick and makes a great alternative... more » By Will  - 7 Nov - 1 new of 1 message

	Transaction load
	Hi there, I have an app that needs to upload a lot of files into my DB, where each file will typically be perhaps 400K but can max out at 16MB (though that would be very rare). Can anyone comment on whether it will heavily tax my system if I wrap each file's upload in its own transaction. There will... more » By Mike23  - 7 Nov - 13 new of 13 messages

	Modify statement to run sp_executesql
	To learn sp_executesql, I create a small code. It works fine as below. CREATE TABLE [dbo].[#A]( [authno] [nchar](10) NULL, [Authname] [nvarchar](50) NULL ) ON [PRIMARY] INSERT INTO #A (AUTHNO, AUTHNAME) VALUES('444' + '~', 'EEE') Once run sp_executesq, got an error said Incorrect syntax near '444'. How to fix it?... more » By aspfun  - 7 Nov - 4 new of 4 messages

SQL 2008 - FILESTREAM OpenSQLFilestream invalid handle

SQL 2008 Express running in Virtual PC on Windows XP Pro, accessed from a "real" machine with Windows XP Pro via TCP/IP and sql authentication (the server has enabled mixed mode). FILESTREAM is enabled for remote client streaming, database allow for Full Access with FILESTREAM. The table is created properly and there's no problem with "traditional" reading/writing... more » By jh  - 7 Nov - 3 new of 3 messages

	Database Table Design
	I have a [user] who belongs to a [group] and writes an [article] using a certain [computer]. The user can move to a different group and a computer can be assigned to a different person. Also, we rent the computers from a company that charges us per hour usage. So we receive a [bill] monthly for a [user] of certain... more » By Jama  - 7 Nov - 4 new of 4 messages

	SSIS hitting FK violation - need to ignore the error rows - have package succeed
	I'm using SSIS and i'm getting a FK violation in my OLE DB Destination task. I'm getting a FK violation and would like to ignore any rows (throw them away) where the error is encountered. The Destination objects doesn't seem able to deal with specific kinds of errors (only able to ignore all errors for example), and i can't get the... more » By Dave  - 7 Nov - 6 new of 6 messages

Output only 255 characters

I have a stored procedure that builds insert statements for the table I pass. This procedure works perfect at my office. But at my client site, it doesn't seem to work correctly. Both are Sql 2008. But one is on a server the other is on a desktop. Not sure why that would be. I was confused as to why my insert statements were getting cut off until I... more » By tshad  - 6 Nov - 3 new of 3 messages