Viewing 15 posts - 3,196 through 3,210 (of 7,429 total)
The problem is only one value can be submitted with one variable. If you need to submit multiples and the possible number is finite (meaning you know how many) then...
March 27, 2003 at 4:22 am
The are some decent template based tools out there but you still have to give thought to your goal and what you need to add to those templates. Query Analyzer...
March 27, 2003 at 4:13 am
I don't recall any upgrade pricing available from MS on this. You are going to get a better answer by speaking with their sales department.
March 27, 2003 at 4:09 am
The first place I would try is the MDAC and make sure that both instances are at the same level. The is a tool to check on the MDAC site...
March 27, 2003 at 4:08 am
It is common to see folks create a single view of the data from which to query and that can be more overhead than you need each time it runs....
March 27, 2003 at 4:00 am
Sorry, my brain just isn't glued in place this week. You can do a full restore but the upgrade of the DB to the 2000 format does require no standby....
March 27, 2003 at 3:42 am
Unfortunately you cannot use Text as a local verible type (only in SPs as input/output but not internal variables).
March 26, 2003 at 4:21 am
Are you needing to view remotely all traffic to and from the server or just to and from your machine. If to/from the server I would first make sure sniffing...
March 26, 2003 at 4:19 am
When you deal with an extreme number of joins performance can degrade exponentially. 4 is common to see but I have situations with 12 or more joins and some are...
March 26, 2003 at 4:11 am
You can restore a SQL 7 Backup to a SQL 2000 server (I do this almost every day from my prod 7 server to my local test 2K server) and...
March 26, 2003 at 3:58 am
It was called EMA (Emnterprise Memory Architecture) in SQL 7 and is available in Enterprise Edition only. Not sure if the /3GB switch in the boot.ini for Win2K will have...
March 20, 2003 at 6:31 am
Could you post a snippet of what you did because you cannot set a text variable within an SP every way I tried and have seen no working method otherwise....
March 18, 2003 at 6:14 pm
First you can use Text datatypes for SP as input or output variables. Don't ask how works as output variable as I have seen no workable way.
Other than that text...
March 18, 2003 at 3:36 am
Please do not cross post. See/leave replies in thread http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=10636&FORUM_ID=8&CAT_ID=1&Topic_Title=Showing+Date%2FTimes+adjusted+for++remote+locations&Forum_Title=T%2DSQL
March 17, 2003 at 3:24 am
Assuming US, Daylight Savings Time adjustments are based on the first Sunday of every April and last Sunday in October at 2AM. We hand calc ours and store the base...
March 17, 2003 at 3:23 am
Viewing 15 posts - 3,196 through 3,210 (of 7,429 total)