Viewing 15 posts - 3,151 through 3,165 (of 7,429 total)
One way I have considered was using CAPICOM from MS (which is freejust search for in MSDN) and do like so.
Write a small app to Input the Stored Procedure in...
April 11, 2003 at 3:45 am
My understanding is no. However here is the MS KB Article on it. http://support.microsoft.com/default.aspx?scid=kb;en-us;813944
April 11, 2003 at 3:39 am
The backup format between 6.x and 7 was changed. You actually will need to use the upgrade wizard to do what you want. The utility is usually under "Microsoft SQL...
April 11, 2003 at 3:35 am
First I would suggest you went to far with table 2 and would just make part of table 1 as the data does not duplicate it is just nullable data....
April 11, 2003 at 3:32 am
Look up Blockbox in SQL BOL.
Here is one excerpt and I have used it on several occasion with a previous issue on a 7 box.
April 11, 2003 at 3:22 am
Normally you don't run traces on a Production server unless you absolutely need to. However, the blck box trace is designed to be saved locally and the data is not...
April 10, 2003 at 7:30 am
I would log into the server wih the user being connected with thru Access. Then I would run those queries to see what effect that has. Eliminate first SQL side...
April 10, 2003 at 5:03 am
Run DBCC CHECKDB to see if it reports anything unusual. But based on the message I would verify I don't have a corrupted index.
April 10, 2003 at 4:48 am
quote:
"Middle initial parsed from first_middle"
If you are getting that as a result then there is...
April 10, 2003 at 4:47 am
Actually I prefer the method of backup and restore to new database. This guarantees exact copy of the database, objects, permissions, the works just like the copy database objects in...
April 10, 2003 at 4:41 am
There might be other ways but right off you are looking for something like this
Select emp, sal from
( -- List all employees and their salaries
select emp, sal from account
union
select...
April 10, 2003 at 4:38 am
Did you use the VC++ Extended Stored Procedure template? And what issue did you run into. I had a couple I hit but I have a Random number generator XP...
April 10, 2003 at 4:26 am
But what's funny is it is not as arbitrary as one would think. When I tested mine example I always got the same results and it differs between SQL 7...
April 10, 2003 at 4:22 am
Sounds like you are importing an Access database in your package. Make sure the table being inserted into can accomidate the data that is coming from the Access DB. If...
April 10, 2003 at 3:52 am
However if you do decide to use MSDE I would suggest creating a version without MSDE that can be installed to a SQL Server of the users choice or even...
April 10, 2003 at 3:49 am
Viewing 15 posts - 3,151 through 3,165 (of 7,429 total)