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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|