Viewing 15 posts - 3,136 through 3,150 (of 3,221 total)
I hope you are aware that Excel 2007 is based on XML ... so far this is the only documentation I was able to find that appears to have a...
April 2, 2008 at 2:03 pm
Kinda of late to get into this subject but from various SSC contributors (whom I thank) patched together this procedure to tell you more than you wanted to know about...
April 1, 2008 at 7:42 am
This one darn near drove me nuts - what with 3 possibilities 2K, 5K, with 2 compatibility levels - so my answer was more of a pseudo psychological analysis which...
March 31, 2008 at 8:56 am
First off let me say I function as a developer not as a DBA. I found this site when using google in an attempt to answer a specific SQL...
March 27, 2008 at 6:52 am
BEGIN TRAN
INSERT INTO T_CONFIRMED_ORDERS VALUES(@orderNumber,GETDATE(),'SETConnector',GETDATE(),null,null,null);
COMMIT TRAN;...
March 20, 2008 at 11:06 am
share your knowledge with others. With the power of so many minds working on problems and sharing their accomplishments, who knows what we will accomplish?
Thanks - an...
March 20, 2008 at 10:02 am
I just read Saturdays news letter and it may have an idea for you
When you upgrade to SSIS, you can see a dramatic improvement in performance. For example, I took...
March 17, 2008 at 12:32 pm
TRACEY,
Thanks copied your posting and it works in 2000 and Express 2005.
March 17, 2008 at 11:56 am
dileep_ratnayake (3/15/2008)
i think i sorted the slow problem out. but do u think vb6 and sql 2005 may...
March 17, 2008 at 10:51 am
For further discussion see the blog post by
Il-Sung Lee Program Manager, SQL Server Protocols
at http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx
March 11, 2008 at 7:18 pm
I owe this to a person or persons unknown but it worked for me.
Run sp_who or sp_who2 to obtain the process id (spid) then
DECLARE @Handle binary(20)
SELECT @Handle =...
March 7, 2008 at 10:43 am
From: SQL Server 2005 Books Online (September 2007)
http://msdn2.microsoft.com/en-us/library/ms187072.aspx
Cut and pasted from the reference supplied by the question:
SQL Server 2005 distributed queries have been tested with several OLE DB providers....
March 4, 2008 at 7:39 am
the database is a mess and the web programmers put in all embedded SQL in the web programs so I have no idea what is going on when something goes...
February 25, 2008 at 12:51 pm
Not a guru but a thought, since you have the column ID (assuming it is the column with the error) use this column Id as a parameter in a T-SQL...
February 20, 2008 at 2:28 pm
Adding to the ideas of WillyWonka. Try this site
http://msdn.microsoft.com/msdntv/episode.aspx?xml=episodes/en/20050512SQLServerDF/manifest.xml
Extract from the site page:
"Data quality is a critical issue in data integration. Donald Farmer introduces the data quality...
February 14, 2008 at 9:40 am
Viewing 15 posts - 3,136 through 3,150 (of 3,221 total)