Viewing 15 posts - 7,306 through 7,320 (of 7,428 total)
Even if you are worried about renaming keep in mind you can make a full backup of one database and restore it over another. As long as you did not...
February 8, 2002 at 11:06 am
Can you post that section of code with username as username and password as pword so I can see what it does.
February 8, 2002 at 10:55 am
SELECT mx.COL1, mx.COL2, mn.COL3, mn.COL4 FROM tblNameHere AS mn
INNER JOIN
(SELECT COL1, MAX(COL2) AS MAXCOL2 FROM tblNameHere GROUP BY COL1) AS mx
ON mn.COL1 = mx.COL1 AND mn.COL2 = mx.COL2
This is as...
February 8, 2002 at 9:38 am
Actually looking at profiler you usually see @P1 and so on get declared and set in the text. They normally only show under RPC items and text looks like this...
February 8, 2002 at 6:03 am
I would think so either. However if you DTS the data into SQL you can do this regularly without users interference. So they can access the SQL more effeciently while...
February 8, 2002 at 5:34 am
You will need to install the Oracle client lincensed from Oracle. Then you can create a DTS package on the SQL Server to import the data on whatever basis you...
February 8, 2002 at 5:26 am
That is about the only way I see it can be done. Or if the client cannot do this for you and each person logs in uniquely you could create...
February 8, 2002 at 5:24 am
Simple way microsoft does it in EM, but keep in mind this does not transfer permissions. I am working on that, and may cause some other issues that I am...
February 8, 2002 at 5:18 am
Also keep in mind that stored procedures may require you giving at minimum read rights to the base tables. But this gives you far better control over what a user...
February 8, 2002 at 4:41 am
You could run Profiler to get HostName for sure and LoginName. I would capture HostName, LoginName, TextData, AplicationName and StartTime as the bare minimum. Also I have the output goto...
February 8, 2002 at 4:31 am
First I have no beef with Microsoft and have done several betas especially .NET, I was merely pointing out that I was surprised with all the antitrust suites that a...
February 7, 2002 at 7:04 pm
I don't believe the ODBC connector you are using supports multithreading. Many times ODBC connectors are not multithreaded capable and actually have only one instance in memory of the ODBC...
February 7, 2002 at 5:23 pm
Sorry poor wording on my part. Let's see. Microsoft being allowed to continue as is without being broken up or forced to open source when .NET posses such a great...
February 7, 2002 at 5:16 pm
Hem, odd. Does not do this to me. I must check further into this. as 0 always is 0 and when it compiles it should never have to check again....
February 7, 2002 at 5:11 pm
Viewing 15 posts - 7,306 through 7,320 (of 7,428 total)