Viewing 15 posts - 5,611 through 5,625 (of 7,429 total)
I didn't say it didn't offer anything but consider the fact you can create full C++ classes and utilize them in VB.net so that cross bread is more natural as...
June 3, 2002 at 8:00 pm
Same as previous except extended a bit, was doing when other came thru so didn't see.
This is a concept piece so I really haven't tested, but should be sound.
DECLARE @ctrlLoop...
June 3, 2002 at 7:41 pm
SET NOCOUNT ON turns off the record affected messages which can cause issues with your recordset if you have an insert and a select. Also elminating these messages reduces overhead...
June 3, 2002 at 7:17 pm
Here is what I believe will work. Depending on how your client works create a versions database that the client can connect to, check for the version it wants, returning...
June 3, 2002 at 6:16 pm
I don't have profiler here in front of me. But I would audit logic and logouts (connect, existing connection, disconnect with 7), error messages, and sql stmt begining and completed....
June 3, 2002 at 6:11 pm
Technically your app should be designed to rmemeber the last input and force them to enter a reason there. The only reason you would put this kind of business logic...
June 3, 2002 at 6:09 pm
You may be able to just open and resave the package then delete the prior versions and see if this helps.
"Don't roll your eyes at me. I will tape them...
June 3, 2002 at 6:03 pm
Do not delete directly, try to determine which stats they are from and delete that stat set. They do use space but it should be very minor.
"Don't roll your eyes...
June 3, 2002 at 6:02 pm
Not sure. This is the steps I follow.
Shutdown SQL
Open Command Prompt
Type path and sqlservr.exe -c -m (Copied from service command line)
Wait recovery complete message
Open EM and drill to server
I have...
June 3, 2002 at 6:00 pm
Please do not crosspost, duplicate message see http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=4593&FORUM_ID=8&CAT_ID=1&Topic_Title=Easy+way+to+View+Totals%3F&Forum_Title=T%2DSQL for responses.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
June 3, 2002 at 5:56 pm
Glad to hear you found a solution.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
June 3, 2002 at 5:55 pm
There are a few syntax differences and sometimes requires you to rethink what was going on to come up with the right solution. As for
June 3, 2002 at 5:52 pm
quote:
but there are other variables - commercial, employee related (what they want to do), career related, the perception that VB.NET is not...
June 3, 2002 at 5:48 pm
Also it is a good idea to build your application so it logs the actions it was doing right before the deadlock ocurred and if you don't have too many...
June 3, 2002 at 5:42 pm
Try response.write cmd.parameters(1) (may be 0 but try 1 first).
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
June 3, 2002 at 11:40 am
Viewing 15 posts - 5,611 through 5,625 (of 7,429 total)