Forum Replies Created
Viewing 15 posts - 6,406 through 6,420 (of 7,471 total)
-
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...
-
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
-
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...
-
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
-
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.
-
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
-
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...
-
RE: @@servername
don't mess with systemtables
-
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 !
-
RE: @@servername
did you also alter the physical servers name ?
-
RE: Can alter table via EM cause a disabled trigger to be enabled?
which version of sqlserver is this ?
-
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 !
-
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...
-
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]]
-
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...
Viewing 15 posts - 6,406 through 6,420 (of 7,471 total)