Viewing 15 posts - 37,906 through 37,920 (of 39,496 total)
February 28, 2002 at 5:04 pm
Have you rebooted and restarted? I thought this was the service account not having permissions.
Steve Jones
February 28, 2002 at 3:21 pm
February 28, 2002 at 3:05 pm
February 28, 2002 at 1:40 pm
The stored procs and views, etc. will mostly run in memory, so more is better. You can separate the data, however, using filesgroups and place heavily used data on separate...
February 28, 2002 at 1:38 pm
Haven't tried it, but I have seen others report errors. SQLMaint seems to be, imho, not a really solid piece of code.
I implemented my own with DTS where I http://ftp...
February 28, 2002 at 12:28 pm
Which version of SQL? I believe with v7 and 2k, this is always present. So when you add a login, you choose an NT login rather than a SQL login...
February 28, 2002 at 12:26 pm
February 28, 2002 at 12:26 pm
I believe you need to be a sys admin, but it might work for a db owner. You need to use integrated security (Windows Auth) if you want someone other...
February 28, 2002 at 10:26 am
Jon's approach is a great one for reducing the load on the server.
One question, when you do this, does the stored procedure recompile? I am curious if the CASE...
February 28, 2002 at 9:46 am
I agree there will be duplicate records. However as suggested above, this is a tradeoff. The join is a simple item and you can easily test for duplicate Staff records...
February 28, 2002 at 9:44 am
Interesting. Can you open this in the Data Transform task using the "preview"? Does it look ok?
Can you open them in notepad?
You might need to open and convert these to...
February 28, 2002 at 9:40 am
this will be tough to plan for. A few questions and suggestions:
1. How many users (concurrent and max) do you have now?
2. Is this a web based application now?
3. Do...
February 28, 2002 at 9:34 am
1. Always search for a SET oriented approach.
2. Smack developers who present you cursor solutions.
3. Have someone else look over your code if possible as a sanity check. This includes...
February 27, 2002 at 4:47 pm
Viewing 15 posts - 37,906 through 37,920 (of 39,496 total)