Viewing 15 posts - 39,286 through 39,300 (of 39,605 total)
If you are really concerned, do a backup at the beginning of the hour, right before the time change, and then one later.
Steve Jones
October 26, 2001 at 10:33 am
October 26, 2001 at 10:31 am
Also, Queue can be either MSMQ or just a table in SQL Server that holds the status about what you are trying to process.
Steve Jones
October 26, 2001 at 10:30 am
BCP can be tricky and requires exact formats. You might try experimenting with the format files, or even extract a row from your table with BCP and save the format...
October 26, 2001 at 10:27 am
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
Viewing 15 posts - 39,286 through 39,300 (of 39,605 total)