Viewing 15 posts - 4,186 through 4,200 (of 7,502 total)
- Set up your service account security decently.
Give each instance its own set of accounts, also keep at least sql-user-passwords different per instance.
- also keep in mind, by applying e.g....
January 7, 2009 at 11:32 am
Still you need to investigate why there is no range joining for ranges that deffer only 1 day (end to next start).
I've messed around this procedural code, and all matching...
January 7, 2009 at 6:05 am
GilaMonster (1/7/2009)
...Please post SQL 2000-related questions in the SQL 2000 forums in the future. If you post in the 2005 forums, you're very likely to get 2005-specific solutions.
Aarch... yes, overlooked...
January 7, 2009 at 3:17 am
You need to dig deeper into the backup file content.
Can you post the results of
restore headeronly
from disk=...
RESTORE VERIFYONLY
from disk=...
restore labelonly
from disk= ...
January 7, 2009 at 3:12 am
Kinnari Thaker (1/7/2009)
Restore Databasefrom disk = 'D:\Dr. Acharya\ManCanDoSql.bak'
I also tried the above command with 'with replace'
It should be :
Restore Database YOURDBNAME
from disk = 'D:\Dr. Acharya\ManCanDoSql.bak'
But you should first figure out...
January 7, 2009 at 2:14 am
Searching if this bug was know by MS, I stumbled onto:
http://support.microsoft.com/kb/951188
This kb does not 100% describe the symptoms I experienced, it states the hotfix was included in Cumulative Update 7.
The...
January 7, 2009 at 2:06 am
Lynn Pettis (1/6/2009)
ALZDBA (1/6/2009)
Lynn Pettis (1/6/2009)
This may be a dumb question, how do I get to the files in the exe file? I've never had to do that before.
I...
January 7, 2009 at 1:37 am
GilaMonster (1/7/2009)
ALZDBA (1/7/2009)
However there may be a TEMPORARY bypass by using the startup parameter that has been provided for the "views with order by nolonger work" problem.
With one caveat:
From the...
January 7, 2009 at 1:04 am
sqlcool (1/6/2009)
is it acceptable?
how to make it better performable?
if indexes cannot be dropped and essential for the system is there ay other...
January 7, 2009 at 12:49 am
Once again a UDF got you in troubles because of hidden joins !
You should really rework that to proper joins in you calling queries and get control over you queries.
However...
January 7, 2009 at 12:42 am
Like Gail said, you should first figure out if that is the cause of you cpu hog.
Use SQLserver profiler and Windows perfmon to figure out what's goin on !
You could...
January 7, 2009 at 12:29 am
Kinnari Thaker (1/6/2009)
I get following error when i try with query analyzer:
'It is not recognized resotre option'
what does...
January 7, 2009 at 12:23 am
Better would be to use the information schema views.
Keep in mind that sql2005 only show object definitions you are granted to view.
(view definition granted)
Is this what you're looking for ?
SELECT...
January 6, 2009 at 1:22 pm
Lynn Pettis (1/6/2009)
This may be a dumb question, how do I get to the files in the exe file? I've never had to do that before.
I don't know it...
January 6, 2009 at 12:56 pm
Ells (1/5/2009)
I have read Gails post and very informative it is. I will look at the other blog. I have a feeling that there are no trasaction log backups...
January 5, 2009 at 6:19 am
Viewing 15 posts - 4,186 through 4,200 (of 7,502 total)