Viewing 15 posts - 38,191 through 38,205 (of 38,242 total)
I usually setup MSSQL and SQLAGent to run under a domain account that is a member of some global group so I can assign rights. The account is a local...
July 26, 2001 at 8:42 am
I used the MeasureUp for the SQL 7 Design exam. It was ok. I've used Transceders for NT 4 exams and they are good, but as a last minute prep...
July 24, 2001 at 8:39 pm
I fyou change the IIS service to not run the file does it work? I think that you disable te service, start the install and IISReset restarts IIS which can...
July 24, 2001 at 4:06 pm
Your post doesn't make much sense.
Your system DSN specifies the type of authentication (NT Auth or SQL Auth). If you are using NT Auth, then the authentication will actually occur...
July 24, 2001 at 3:14 pm
I haven't seen this with SQL. I've installed dozens of workstations and servers, all W2K, no issues. This is usually one of the cleanest installs I have seen.
I would dbl...
July 24, 2001 at 3:01 pm
I assume you have the default W2K settings? Verify this. Be sure no one has changed items on the server.
Also, is SQL running as a local admin? This might be...
July 24, 2001 at 2:49 pm
You can get the sizes for most datatypes, etc. from BOL or use INSIDE SQL Server by Kalen Delaney. It's a great reference.
The hardest part will be estimating growth. Get...
July 24, 2001 at 2:44 pm
v6.5 will run on W2K, but there are issues with getting it setup. I would be careful. Better yet, upgrade to 2000 and run in v6.5 compatibility mode.
I've done this...
July 24, 2001 at 2:40 pm
Answer: (hate to say it) It depends. I have a SQL Server with 512 that hums. Depends on the load. If you are getting lots of paging and the site...
July 20, 2001 at 1:05 pm
If you declare it as @oppid, does it work?
Haven't really worked with collation, but I will try to alter a server here and see.
Steve Jones
July 20, 2001 at 12:43 pm
Can you post more information? I am not sure what you mean.
Also, you should be able to go to the Services item in control panel and stop and start SQLAgent.
Steve...
July 20, 2001 at 12:38 pm
There are lots of features, but if you are not using them, do you care? Maybe, but it might be difficult to test some things (replication) if you are not...
July 18, 2001 at 4:19 pm
July 18, 2001 at 4:09 pm
I agree with Andy. PK, FK are great choices for non-clustered indexes.
Then look at which queries are run often. It doesn't do much good to index (clustered) for a...
July 18, 2001 at 4:06 pm
I think that based on this, you need separate fields in SQL Server for each extent. Then this
DTSSource("meatcost__1")
Needs to return the correct value.
Will this work to a text or...
July 18, 2001 at 3:55 pm
Viewing 15 posts - 38,191 through 38,205 (of 38,242 total)