Server Configuration

SQLServer 2005 - (XML Datatype)
I'm trying the Beta2 for SQL Server 2005, and in documentation we have references to a native datatype XML. When I try to create a table with that datatype I receive the error: Column or parameter #1: Cannot find data type XML. Any clues....: Tks ... 22 Feb 2005 09:34

VSS with SQL server
Has anybody used VSS with sql server to control the code changes of sql server objects? what is the best way to setup and use it? please advice . thank you sam ... 22 Feb 2005 09:34

Remote access not allowed for Windows NT user activated by SETUSER
i can login as an SQL Server user (FinanceArchiveTraining), and run my desired stored procedure. This sp accesses a linked sever. i want a scheduled job that does this for me. But of course i get: Remote access not allowed for Windows NT user activated by SETUSER What magical combination of the job's "Own... 18 Feb 2005 15:45

Error Message: SQLState 'S1000' Cannot generate SPPI Context
Users are getting this message consistently now. It is a SQL backend with a Microsoft Access front end. The only way I have figured out so far on how to access the program is by restarting. Does anyone have an idea what the problem is and what I can do to solve it? Thanks in advance ... 18 Feb 2005 12:40

Error Sorting
I need the results of a view sorted by date. When the order by date is added to the view I get the following error from SQL/ODBC SQL Driver: "cannot sort a row of size 8813, which is greater than the allowable maximum of 8094" Is there a way around this? Thanks ... 17 Feb 2005 02:39

LOG Error Mssgs
I've found very little information on the following error mssg's, can someone point me in the correct direction or offer advice. It appears this may be related to our backup software - Veritas but I don't think this is the only issue. Below are 4 of many error mssgs. Thanks, Liz BlkHeader from strip 1 At 4... 16 Feb 2005 18:01

ldf file missing...
If its not important to get the log file back then I sugest you use the Enterprise Manager tools. Firstly if you haven't already done it detatch the database If your log file still resides on the machine then either rename it or delete it (renaming is better to begin with). Then still using the enterprise ... 16 Feb 2005 13:55

execute dts package using xp_cmdshell
How to use xp_cmdshell to execute dts package? I used the following command: EXEC master..xp_cmdshell 'dtsrun /SServerName /Uuid /Ppassword /Npackagename' This returns an error and package did not executed. Any suggestions? Thank you very much! ... 16 Feb 2005 09:50

Suspect Database - Please Help
Dear All, Our database was maked as suspect today, I ran the store procedure exec sp_resetstatus 'DBNAME' but got the message 'Prior to updating sysdatabases entry for database 'ParisProduction', mode = 0 and status = 16 (status suspect_bit = 0). No row in sysdatabases was updated because mode and status ar... 12 Feb 2005 17:12

Windows Delayed write error when backing up to network share
I'm running SQLServer2000 SP4 on two separate servers. The problem I'm running into is that when I schedule a database backup either through Maintenance Plans or manually through Enterprise Manager the backup fails with the error: "Windows-Delayed Write Error. Windows was unable to save all the data for the f... 12 Feb 2005 17:12