Viewing 15 posts - 451 through 465 (of 1,248 total)
Did you confirm the password to start your srevices correct?
April 15, 2008 at 1:55 pm
jezemine (4/9/2008)
should be no difference in client tools for standard and enterprise.http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
Could you give me a source showing there is no difference?
I searched the article in your link by client...
April 9, 2008 at 7:33 pm
This error may be hardware related, but not always true. See the link below.
April 9, 2008 at 3:27 pm
Check you log file size. If it is bigger than your expectation, you may try the following approaches.
1. Have transactional log backups regularly;
2. Turn the recovery mode of this database...
April 9, 2008 at 3:21 pm
From Enterprise;
Right-click SQL Server Group;
Choose New SQL Server Registration ...,
...
You would not miss it.
April 9, 2008 at 3:13 pm
Please provide your query. I am pretty sure some people will help you out.
April 9, 2008 at 3:09 pm
VARCHAR(50) and DECIMAL(18) are not good candidates for indexing. If you cannot modify indexes, you may not have choice.
In principle, data type of column chosen to be indexed should not...
April 9, 2008 at 3:05 pm
Try this, if you do not like FULLSCAN,
EXEC sp_msforeachtable 'UPDATE STATISTICS ? WITH SAMPLE 20 PERCENT'
April 9, 2008 at 3:01 pm
Here are two links
http://www.devarticles.com/c/a/SQL-Server/Replication-SQL-Server-2000--Part-1/
http://www.devarticles.com/c/a/SQL-Server/Replication-SQL-Server-2000-Part-2/
Mat they help.
April 9, 2008 at 2:57 pm
As far as I know, the only difference between Enterprise and Developer versions is the later has limited cocurrent users.
April 8, 2008 at 8:56 pm
Did you try to grant SELECT permission to PUBLIC?
April 8, 2008 at 8:48 pm
ERRORFILE can be used in SQL 2005. See the following links
http://msdn2.microsoft.com/en-us/library/ms188365.aspx
http://support.microsoft.com/kb/919775
http://www.sqlservercentral.com/Forums/Topic447601-338-1.aspx
In SQL 2000, although running BULK INSERT ... WITH (ERRORFILE ...) does not give us any error, the system ignore...
April 8, 2008 at 8:44 pm
Do you mean the total cost is 99% when you wrote anything wrong in the execution plan?
April 8, 2008 at 8:12 pm
Viewing 15 posts - 451 through 465 (of 1,248 total)