Viewing 15 posts - 856 through 870 (of 984 total)
Got it. Your list of database names isn't quite right...
you've got
AND dprin.name NOT IN (''public''','dbo'',''guest'',''sys'', ''INFORMATION_SCHEMA'')
where you should have
AND dprin.name NOT IN (''public'',''dbo'',''guest'',''sys'', ''INFORMATION_SCHEMA'')
August 16, 2012 at 8:53 am
thomasrichardson2000 (8/16/2012)
(Vehicle.value + Vehicle.Extras_Value + Vehicle.Expenses + Vehicle.Another_Tax + Vehicle.Other_Extras_Value) AS NetCost
basically I am trying to add and subtract columns to get a...
August 16, 2012 at 8:39 am
Hurrah! This has solved a problem that's been bugging me for a few days. Thanks!
September 14, 2010 at 3:15 am
Hugo Kornelis (6/28/2010)
Preet_S (6/28/2010)
There does seem to be an obsession with points, but if a question is posted it should at least be "right".
Agreed. But on the other hand, writing...
June 28, 2010 at 4:26 am
Definitely at least one typo in this...
Is there no checking / validation of these questions before they go live?
June 28, 2010 at 4:03 am
I have run 6.0, but not for a *very* long time. My first SQL Server was 4.21, and I've worked with every version since then. To be honest,...
June 25, 2010 at 3:27 am
CirquedeSQLeil (6/9/2010)
You may want to look into getting a SAN as well. At least it should be an option.
Definitely.
See? I told you somebody else would be along with...
June 9, 2010 at 9:53 am
NitroBoarder (6/9/2010)
Thanks for all the advice.I will talk to our systemadministrator to see if i can get some new hardware...luckely he always likes ordering new servers 🙂
Well, if you're going...
June 9, 2010 at 9:47 am
Assuming this is a dedicated SQL Server, I would start with the following:
Drive 1: OS, system databases, tempdb
Drive 2: Databases
Drive 3: Logfiles
I would see how that performs, keeping an eye...
June 9, 2010 at 4:11 am
gsingh0904 (6/9/2010)
June 9, 2010 at 3:44 am
RicardoRincon22 (6/8/2010)
I'm a recent IT graduate (major in db's). I've been looking for a DB job for 6 months now. (I'm in the UK)
I have been looking at job titles...
June 9, 2010 at 2:43 am
gsingh0904 (6/9/2010)
How we can check if mpp has sql server acct permission or not? Do I need to add any user to that file? if so, how can...
June 9, 2010 at 2:31 am
gsingh0904 (6/9/2010)
June 9, 2010 at 1:15 am
gsingh0904 (6/8/2010)
If we use Microsoft.Project.OLEDB.11.0 library (MDAC2.8) in VB.net application, after shipping to end use, It prompts Microsoft.Project.OLEDB.11.0 is not registered( its right because end...
June 8, 2010 at 12:24 pm
http://www.connectionstrings.com/ms-project
Do you have MS Project 2003 SP3 installed?
June 8, 2010 at 9:21 am
Viewing 15 posts - 856 through 870 (of 984 total)