Viewing 15 posts - 39,151 through 39,165 (of 39,466 total)
Can you connect with Query Analyzer?
right click the registration in Enterprise Manager and select "connect".
what happens? Pls post exact errors.
Steve Jones
October 26, 2001 at 10:25 am
Looks like the client is using Multi-protocl encryption. Check your default network connection using the client network utility.
Steve Jones
October 26, 2001 at 10:23 am
Can you run the sp_attach_db and post the exact code run and the exact error message from Query analyzer?
Steve Jones
October 26, 2001 at 10:22 am
I do this on a regular basis and import into a staging table. Then I have a sproc that updates changed records (by matching PKs) and deletes them from the...
October 26, 2001 at 10:21 am
I agree. This isn't many rows, and more indexes than I like, but 7 isn't too many. You should be able to delete 20k rows in seconds.
BTW, how many is...
October 25, 2001 at 10:23 pm
Wouldn't the web server process the request and generate the pdf? We used a product called Active Reports that does this. The web page instantiates the object, calls SQL to...
October 25, 2001 at 10:22 pm
I know, I'm late. I've been meaning to read this all week, but I kept putting it off.
OK, here it goes.
I think Andy has done a great job pointing out...
October 25, 2001 at 4:55 pm
October 25, 2001 at 2:06 pm
Both should be provided by the client. QA will provide those to the server on connection. That's why you often see very little information from sp_who2 when a web app...
October 24, 2001 at 10:29 pm
The first time you assign an account to a server, W2K should automatically grant the "run as a service".
Keep in mind that when you execute a package, it runs in...
October 24, 2001 at 10:27 pm
You can do a SET SHOWPLAN_TEXT ON before running the query to get the query plan.
Or SET STATISTICS IO ON
Steve Jones
October 24, 2001 at 10:22 pm
Ahhhhh
Sorry. I started looking at it and got distracted. I didn't see anything off the top of my head. I started testing with my own package, but didn't finish. I'll...
October 24, 2001 at 10:20 pm
off the top of my head, nothing. Can you post the ddl for the db. I'll try some experiments.
Steve Jones
October 24, 2001 at 7:02 pm
So this file does not get created?
I'm sorry for continuing to ask questions, but it is confusing in your post.
A couple things:
Are you running this from the local console on...
October 24, 2001 at 3:06 pm
Yes, there is 25 bytes. If you change to char columns, you can get to 8039. Each var column has 2 bytes of overhead.
There are 21 bytes of overhead for...
October 24, 2001 at 3:00 pm
Viewing 15 posts - 39,151 through 39,165 (of 39,466 total)