Viewing 15 posts - 556 through 570 (of 583 total)
Even though the same error message is mentioned in the articles, neither one addresses my issue. I have modified my proc to use a cursor to read each row...
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
April 28, 2003 at 8:56 am
Thanks!
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
March 26, 2003 at 11:37 am
Yes, that is true. We are running Advanced Server.
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
March 24, 2003 at 8:03 am
Yes, there are other things going on. It has some PeopleSoft scheduled tasks running. I can see in the log that SQL is releasing a little bit of memory...
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
March 21, 2003 at 8:13 am
Great, sounds like Standard edition is the way to go.
Will the /3gb switch really do anything if there are 3.6 gigs not 4? Will it help...
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
March 20, 2003 at 5:36 pm
I'm even more confused on this now. I thought that the 3 gig switch was part of AWE since it is discussed in the BOL article "Using AWE Memory...
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
March 20, 2003 at 3:01 pm
I just had an idea about this.
Maybe SQL has too much memory. The memory is dynamically configured and the "Total Server Memory" counter is at 1.6 gigs. So,...
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
March 20, 2003 at 9:25 am
The command line is not bad, it doesn't scare me, just my boss. Also, it would be easy to write scripts or a VB front end if needed.
Evidently, we are...
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
March 9, 2003 at 8:04 am
Check out Brian Kelley's article http://www.sqlservercentral.com/columnists/bkelley/sp3coresecurity.asp about SP3. He says "The reason for this is simple: if an attacker can access and modify the registry, it's a...
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
February 11, 2003 at 4:46 pm
Here's the problem: There were two settings turned on that shouldn't have been turned on. One was "Use Windows NT Fibers" and the other was "Boost SQL Server...
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
February 11, 2003 at 4:40 pm
Nothing has worked so far. The really odd thing is that in Enterprise Manager and the services applet, it looks like it is running. I have also restored...
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
February 11, 2003 at 10:12 am
The BOL looks like you can do it as long as it is W2k, not NT4. Regardless, rib board, it is.
Thanks for responding.
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
January 19, 2003 at 11:20 am
I found the answer to my problem. You have to copy the installation file to a network share or the local drive. If you try this from the...
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
December 13, 2002 at 3:22 pm
You can also use the Copy Database Wizard. I didn't have any problems with Logins when I used this. Also, it copied my scheduled jobs as well. ...
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
August 26, 2002 at 3:58 pm
Found out how to do it. If you check SQL 7 format, it will encrypt each parameter instead of the entire line.
Thanks for all of your help!!!
Kathi
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
August 19, 2002 at 12:32 pm
Viewing 15 posts - 556 through 570 (of 583 total)