Viewing 15 posts - 16,411 through 16,425 (of 39,827 total)
Personally what I would do is make a small db on all servers for your admin stuff. Then have a job that populates a table in this db with the...
April 4, 2011 at 4:06 pm
It's definitely permissions. AFAIK, however, it's the SQL Service account, not the agent account, that needs permissions.
The agent logs in just like you do from your workstation. The backup is...
April 4, 2011 at 3:02 pm
I like Craig's advice, but Michael's is probably where I'd start. Usually shrinkage affects inventory, so I'd compare ordering with sales and look for discrepancies. One of the things you...
April 4, 2011 at 3:00 pm
I like the inventory project. Ought to be fairly simple, and it can be useful.
April 4, 2011 at 2:57 pm
Do you know what shrinkage is, from a data standpoint? Or is that where you are looking for guidance?
Once you define it, then you might play with the data mining...
April 4, 2011 at 12:47 pm
It sounds like someone might have messed with permissions on the server. If you set to LocalSystem as a test, does that work?
April 4, 2011 at 12:35 pm
First, make sure you understand the difference between user and login. You will not necessarily want to remove logins. If you are restoring, then you should understand what the implication...
April 4, 2011 at 12:34 pm
The biggest problem I've heard about is the lack of additional tuning done with the ORM tools. Implicit conversions with varchar -> nvarchar (and vice versa) can be an issue,...
April 4, 2011 at 12:23 pm
Can you not join all three tables on the ConsignmentValue field and just display the date?
select a.date1, b.date2, c.date3
from a
inner join b
...
April 4, 2011 at 11:30 am
creating a procedure or creating a job is just executing a T-SQL batch. It can be more complicated in terms of permissions and you will have to resolve that, but...
April 4, 2011 at 9:37 am
The other thing I thought about here is what is the second process? What are you doing after 2 minutes. The type of process might dictate what I'd recommend.
April 4, 2011 at 9:26 am
You could do that, but I think you'd have to architect the readers carefully and you might have a scale issue. I'm not sure that the complexity of setting up,...
April 4, 2011 at 9:24 am
I think I'd agree with the last comment. Agile doesn't mean somehow losing control or making changes that are not well thought through and tested. I used to work on...
April 4, 2011 at 9:21 am
Viewing 15 posts - 16,411 through 16,425 (of 39,827 total)