Search results for query: *

Use the ADO command object to execute a sql string. The string should be something like "INSERT INTO myTable....."

Hi, when I try to expand out a project or look at its properties in VBA in excel I get the message 'Project is unviewable'.....the project also has the extension .MRV. Is there anyway I can get around this? Thanks in advance

I got it....Microsoft's Service pack 1 for Office 2k resolves the truncation problem.........incase anyone cares!

Thanks for the reply Robert. I have come across the truncation in query analyser before but that can be resolver by going into current connection option ->Advanced and resetting the character limit. My problem has taken a curious twist though. I have discovered that whilst it happens with...

When I use MS query to pull back data to a mail merged Word document, it truncates any long narratives to 256 characters. But it only does this in Word 2000, and not in Word 97......has anyone out there come across a similar bug - perhaps the bug is in Query 2000!! Is there a patch out there? Help!

Anyone have any idea why when I return a long varchar from SQL through MS Query to a mail merge document that it gets truncated down to 256 characters. I cannot establish whether it is the SQL database or the ODBC connection or the MS Query that is doing it!!!

You owill certainly be able to import tables including data, but querys wont convert to anything and forms will need a VB interface or something, reports will need to be Crystal. So if all you are doing at the moment is creating tables you are probably ok.

17550:DBCC TRACEON 208, server process ID (SPID) 13 Can anyone tell me what this is all about. It is appearing in the event viewer on my server very regularly. The server is hosting a couple of hundred machines all running a VB app that front ends a SQL database. I have searched around and...

Instead of the '=' use the word 'Like' for comparing varchars CREATE PROCEDURE [sp_SWGetOnHandQuantity] @ProdID varchar AS SELECT OnHand FROM tblInventory WHERE ProdID Like @ProdID That should do it

Thanks for trying anyway buddy.....my quest continues, I'll post it on this site if I come across anything

Yeh I meant force them to check it in/out, unfortunately I work in an environment where there are 6 of us working on the same app and the time issues of passing a script to a DBA have forced us down the 'Free for all' road. Thank you for your comments.

What is the word on CR 8. Does it support datetime parameters? And does it's web publishing feature really work?

It's a nice idea Robert but is there anyway that you can actually force it on to other users so that you can lock them out?

Anyone ever come across a Source safe type feature for SQL 7 - third party or otherwise