Server Configuration

Couldnt Take Script using SMO columns binded default values
hi all , i am trying to take the Table Script through SMO , i can take (Table ,PK , FK, but i couldn't take the column binded default values EXEC sys.sp_bindefault @defname=N'[dbo].[def_BitTrue]', @objname=N'[dbo].[tDS_Inst].[IsReviewed]' , @futureonly='futureonly' ... 4 Jul 2008 01:50

Warning 9935 on database restore
Hi, On the same instance of SQL 2005/SP2 (win2003 sp2) if I backup a database with a full text catalog and then restore the database (on the same instance) I get the following warning: Warning: Wordbreaker, filter, or protocol handler used by catalog '%ls' does not exist on this instance. Use sp_help_fulltext... 11 Jul 2008 17:10

connection to sql server 2005 problem
> A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) ====================== See if this helps: http://technet.microsoft.com/en-us/library/ms175496.aspx -Eric ... 3 Jul 2008 23:48

Where discuss SQL 2008?
Is there another forum with more traffic about SQL 2008? Thx, J. ... 7 Jul 2008 22:47

Issue with unclaimed space
Hi all, I think I need to post a result for this orginal post here. It seems I can hardly reproduce this issue in my test enviornment, but it did exist in my production due to the huge concurrencies in production which cannot be easily reproduced in a test environment. What we finanlly decide is to partiti... 3 Jul 2008 16:38

dm_exec_requests start_time not being updated?
I monitor for long running queries by comparing the start_time from dm_exec_requests to getdate() to see how long a session has been running. I recently got alerted for a long running query but on closer inspection there was no long running query. It appears that the start_time column for the session in question wa... 3 Jul 2008 14:34

Trouble with SQL2005 sp_cycle_errorlog
Hi, We reboot our servers only once a month for patching and so we cycle the SQL errorlogs twice a week to keep them to a reasonable size. Every now and again a problem happens with our SQL Agent job that cycles the errorlog. Last night the job reported as run successfull but a new errorlog file was not prod... 3 Jul 2008 17:40

SQL Server Failed Assertions
I'm running SqlServer-2005 SP2 x64 I am getting the following 2 Failed Assertions: SQL Server Assertion: File: "xact.cpp" line = 2879 Failed Assertion = '!m_updNestedXactCnt' Trying to use the transaction while there are 1 parallel nested xacts outstanding. SQL Server Assertion: File: <lckmgr.cpp><c/> line... 3 Jul 2008 19:43

FOR XML data vs Recordset
Hello, I have an option to return data from a stored procedure using XML or recordset. I do not intend to do any sort of XSL or anything but would be transforming them into typed objects in the Data access layer. Does anyone know of the performance differences when a stored procedures returns XML data using "F... 3 Jul 2008 11:29

SQLServer2005\DatabaseDiagram\Owner
I have a database that my client sent me for testing an application on. I setup a new database with the same name as my clients server was using and did a restore to get it installed on my machine. I was wanting to do a Database Diagram of it, but when I try to open up the Database Diagram folder I get the f... 3 Jul 2008 10:27