Forum Replies Created
Viewing 15 posts - 6,436 through 6,450 (of 7,499 total)
-
RE: SQL Server Processor Setup
if this is not a sql2000 sp4 system ...
There have been issues with parallelism with sp3(a), and it took a while until there was a hotfix to overcome the buggy...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: time based recovery
You 'll need your db in bulk or full recovery mode.
check out http://www.sqlservercentral.com/columnists/kKellenberger/restoringtoapointintime.asp
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: I Can''''t connect to SQL Server 2005 via SQL-DMO
From SQLServer 2005 BOL :
Because SMO is compatible with SQL Server version 7.0, SQL Server 2000, and SQL Server 2005, you easily manage a multi-version environment.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: I Can''''t connect to SQL Server 2005 via SQL-DMO
my 2 ct...
SQL Server Management Objects (SMO) is the replacement for SQL-DMO.
Check it out !
Maybe conversion is not _that_ hard
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: Can alter table via EM cause a disabled trigger to be enabled?
In case you were addressing me
:This testscript creates a table and puts an update trigger on it.
The script was initialy for testing...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: @@servername
don't mess with systemtables
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: Can alter table via EM cause a disabled trigger to be enabled?
Your finding is correct !!
It does it wrong in SP3a _and_ SP4 !
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: @@servername
did you also alter the physical servers name ?
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: Can alter table via EM cause a disabled trigger to be enabled?
which version of sqlserver is this ?
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: Copy job get failed when we copy a backup file to network drive
use UNC-naming :
XCOPY C:\MSSQL\BACKUP\*.* \\myserver.mydomain.com\bu2tapeDay$\mysqlservername\Database\ /c /s /k /h /v /y
------ yourfileserver -----\-- share --\-subfolder-\--subfolder--
This is the same stuff you enter when mapping the drive in explorer !
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: master database
first of all : don't mess with master unless you know what you are doing
master keeps the inventory of databases, locations, users,....
It is...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: Can''''t get SQL Server to listen via TCP
Can you check these settings using REGEDIT
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\[yourinstancename]\SuperSocketNetLib\Tcp]
and
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\[yourinstancename]]
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: Copy job get failed when we copy a backup file to network drive
can you post you job's DDL ? (full)
btw don't use a domainadmin account to run your sqlserver !
Keep the guideline...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: Copy job get failed when we copy a backup file to network drive
first check that your sqlserver agent service account has the needed rights to you networkdrive.
I use this doscmd to do the job (without problems)
XCOPY C:\MSSQL\BACKUP\*.* \\myserver.mydomain.com\bu2tapeDay$\mysqlservername\Database\ /c /s /k...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: LEFT OUTER JOIN IS NULL or WHERE xx NOT IN(select..)
just my 2ct
how about ...
Select inv.*
FROM dbo.Inventory inv
where not exists ( select *
FROM dbo.InvHist IH
where IH.InvID = inv.InvID)
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
Viewing 15 posts - 6,436 through 6,450 (of 7,499 total)