Viewing 15 posts - 5,911 through 5,925 (of 6,105 total)
Go into your Server Network Utility and see what TCP port SQL Server should be listening on. Then compare with the netstat -an. If you don't see the...
January 8, 2002 at 1:47 pm
We try our best to keep SQL Server isolated from anything else, even in development. SQL Server will dynamically allocate and deallocate memory based on what else is going...
January 8, 2002 at 12:29 pm
If you run Profiler, you can export the trace to a table and parse away. Either run the trace and have it dump to the table initially, or capture...
January 8, 2002 at 9:51 am
We've had other conversation topics on this... Basically, it's not a good idea to fire the DTS package from a trigger. Better would be to write a table...
January 8, 2002 at 8:35 am
Please do not crosspost. Most of us check all the forums. I have replied in the DTS forum.
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
Edited by - bkelley on 01/08/2002 08:34:47 AM
January 8, 2002 at 8:33 am
At the organization you are at, what is the expected ramp up time before using .NET actively? I know that some companies are in production with .NET apps, but...
January 7, 2002 at 5:11 pm
I don't know if you want to start changing error levels in sysmessages (though you could test in a development environment). As an alternative, are you using SQL Agent...
January 7, 2002 at 5:02 pm
If you link to another SQL Server, use the proper four part naming convention (including owner) to hit multiple databases on the same server... provided the login account being used...
January 7, 2002 at 4:58 pm
I see this in your sproc:
quote:
SELECT @ret "TransDutyCode"
That's probably why you are getting the return...
January 7, 2002 at 10:48 am
Is this an internal or external attack? If external, what do your firewall logs say?
K. Brian Kelley
January 7, 2002 at 9:34 am
Based on BOL, the two conditions where a checkpoint would be set:
January 7, 2002 at 9:19 am
What happens when you execute the stored procedure say from Query Analyzer. I am wondering if Access is the limitation, though I know in my organization we've import ~...
January 6, 2002 at 10:01 am
I'm assuming you are changing the connection settings on the clients... TCP/IP should work. Of course, Windows 98 doesn't support Named Pipes, which is why they have to be...
January 5, 2002 at 4:45 pm
What error are you getting? Is pubs getting backed up as well?
K. Brian Kelley
January 5, 2002 at 3:36 pm
Just checked the web server OSE2K was installed upon. No Excel.
K. Brian Kelley
January 5, 2002 at 3:25 pm
Viewing 15 posts - 5,911 through 5,925 (of 6,105 total)