Viewing 15 posts - 61 through 75 (of 789 total)
You can try a switch like -s"" to reduce the column separator to nothing, which will remove the leading space, but the consequence of this is that no separator will...
June 10, 2004 at 2:08 am
From the xp_smtp site (http://sqldev.net/xp/xpsmtp.htm)....
Note: SQL Server 7.0 and Windows NT 4.0 usage
When using SQL Server 7.0 on Windows NT 4.0, you need to install...
June 10, 2004 at 1:52 am
A cool feature would be "free to all sqlservercentral members".
June 8, 2004 at 10:24 pm
select replace(name, 'Pack of', 'Case of')
FROM dbo.PRODUCT
WHERE (NAME LIKE '%pack of%')
June 8, 2004 at 10:10 pm
If using Profiler you may want to start with monitoring "Log File Auto Grow" (and use the filter to restrict monitoring to the database in question).
Once you've narrowed down WHEN...
June 7, 2004 at 4:22 pm
Martin,
A detach/attach will create a shiny new transaction log file. I'm assuming here that you have just one data (mdf) and one transaction log (ldf) file for this database.
To be...
June 7, 2004 at 5:57 am
...and my newsletter says that yesterday's question was... "Which of the following is not a phase in DTS' multiphase data pump...". Was it??
June 1, 2004 at 3:19 am
alzdba, you're not alone. someone's answering my questions for me too.... AND doing it rather badly.
June 1, 2004 at 2:05 am
Brent,
I suggest you test the integrity of those files in your data folder:
a) install sql2000 on another machine
b) copy the mdf files relating to your user databases (ie....
May 26, 2004 at 11:53 pm
I *usually* find it's a 50%-ish split. If you want some control over the % (eg. 40%/60%) you may have to backup to 5 files (2 on one device and 3...
May 26, 2004 at 5:09 pm
Just use 2 destinations in your BACKUP command. eg.
BACKUP DATABASE mydb TO DISK = 'G:\mssql\backup\mydb1.bak, DISK = 'H:\mssql\backup\mydb2.bak' with init
May 25, 2004 at 6:08 pm
Only one of the paths will be taken. If it meets criteria#1 then it will not be tested for any others.
Note: your CASE excludes an ELSE, therefore Field1 will be...
May 25, 2004 at 6:01 pm
if you're using EM on the actual SQL2000 server on which you've installed, try the registration with "from now on let's do this without the wizard", type in the server...
May 25, 2004 at 5:51 pm
No, SQL2000 spoilt us with its ALTER...SET...WITH ROLLBACK IMMEDIATE|AFTER
In SQL 7 you have to KILL everyone using the database and then do the sp_dboption.
BOL 7.0 confirms that the sysdatabases.status column...
May 25, 2004 at 5:43 pm
It's preferable that they go on physically separate disk arrays, on a separate channel or even better, a separate controller. Logical partitioning really does nothing in terms of performance or...
May 25, 2004 at 5:32 pm
Viewing 15 posts - 61 through 75 (of 789 total)