Forum Replies Created
Viewing 15 posts - 6,436 through 6,450 (of 7,502 total)
-
RE: Row size limits
just my 2ct
nvarchar(..) is double byte so nvarchar(1000) takes max 2000 bytes + length indicator.
making it ntext will allow you to store up to 2G for that column.
Downsides are :
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: Upgrade SQL2ksp4 to SS2005 keeps master dblevel 80 ??
globSMOSrv = the smo.server
as stated in the first of this thread :
oDatabase = globSMOSrv.Databases.Item("master")
in VS2005 immediate window
?oDatabase.CompatibilityLevel
Version80 {80}
?globSMOSrv.Information.VersionString
"9.00.1399.06"
Now what's the point of not having at least the system...
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: Upgrade SQL2ksp4 to SS2005 keeps master dblevel 80 ??
The strange thing is that I can implement storedprocs that use e.g. CTE's and execute them without a problem or warning
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: 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
Viewing 15 posts - 6,436 through 6,450 (of 7,502 total)