Archived Months
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
all groups > sql server new users > february 2006 > threads for february 22 - 28, 2006

Filter by week: 1 2 3 4

Missing topics in help system
Posted by Paul at 2/27/2006 8:38:06 PM
There is no editorial oversight other than marketing? The sql server 2005 help system has the haphazard feel of being written over the weekend (by someone in marketing). Not found in sql server help: formula, formulas, how to write a formula for computed columns rowguid, rowguid columns...more >>


restore
Posted by Troy at 2/26/2006 11:21:29 PM
is it possible to restore a sql 2005 database backup to a sql server 7.0? ...more >>

profiling
Posted by Troy at 2/26/2006 9:29:10 PM
Hello, I have a sql 7.0 server that I want to profile activity on. Is it better to run profiler on the server or remotely? the same question with running performance monitor 24 hrs. Any thoughts? Thanks ...more >>

Hide stored procedure code
Posted by Lasse at 2/26/2006 12:00:00 AM
Hi How do I hide the stored procedure code from be being viewed by others in the sql server enterprise manager? Thanks Lasse ...more >>

remove html function
Posted by Daves at 2/24/2006 4:59:53 PM
(on Yukon) - is there an easy way to remove html tags from nvarchar(max) field? ...more >>

SQL Server 2005 Connection
Posted by Carlos Jones at 2/24/2006 1:01:42 PM
Hello all, I downloaded and installed the SQL Server 2005 evaluation version (full version not the express one) and I do not know how to allow the connection from a remote computer; locally everything seems to work fine, but when I try to create a DSN on my laptop to get access to the S...more >>

How to defrag an SQL 7 AND 2000 server?
Posted by Clayton Sutton at 2/24/2006 9:26:03 AM
Can someone tell me how to defrag. an MSSQL 7 AND MSSQL 2000 server. We have both ver. 7 and 2000 (running on two different systems). I am not a DBA but I really need to get this done tonight (2/24/2006) while we take our systems down. I will also want to defrag the Windows 2000 and Windows...more >>

config question
Posted by Troy at 2/23/2006 7:10:13 AM
hello, we have a dual xeon box with 4 Gb of RAM running windows 2003 sp1 and sql 2000 sp4. The database is 200 Mb and will probably max out at 400 Mb. Is there any way to keep the entire database in memory? Any issues with doing this? thanks ...more >>



managing sql log file(*ldf) growth
Posted by Raajeshh at 2/23/2006 3:00:30 AM
Hi pals, am also having a similar problem to that of Simon. The log files of my server are being stored in D drive of our SQL server which is 120 GB. We have a database maintenance plan & all mdf & ldf files are backed up on a daily basis. the problem is that the log file keeps growing & wi...more >>

Execute failed: Cannot insert the value NULL into column
Posted by countryhouse at 2/22/2006 9:41:40 AM
I have recently attempted to use replication in our SQL2000 server. Since the process installed check columns in the tables, the process was unacceptable for the application we use. Consequently, I turned off replication and removed the columns using some scripts found on a site regarding ...more >>


DevelopmentNow Blog