Viewing 15 posts - 61 through 75 (of 89 total)
Are you running the latest service pack? I have found that there are many problems with replication in the original release and SP1. Things are much more stable...
September 30, 2003 at 2:46 am
Try Dropping the column through Enterprise Manager. This doesn't Alter Table, but scripts a new table, transfers the data and then drops the original and renames the new. ...
September 30, 2003 at 2:38 am
As long as you are not truncating the log on checkpoint (Recovery Model is not 'Simple' in 2000) and you have yet to restore your database you will still have...
September 26, 2003 at 3:23 am
I have always found that for complex IIF(expression,truepart,falsepart) statements there is no real alternative but to convert to CASE WHEN expression THEN truepart ELSE falsepart END. However SQL Server...
September 26, 2003 at 3:09 am
To my knowledge SQL Server does not directly support the scripting of data. However, if you need to script data from an existing table it can be done by...
August 14, 2003 at 2:53 am
Are you coping the database by backing up and restoring?
If so make a note of the destination database file paths, select Restore Database from the menu and when the dialog...
August 11, 2003 at 2:54 am
Remote machines on dial-up connections cannot automatically resolve the server names.
If you are using WINS add an entry for the publisher, or if not add an entry into...
August 11, 2003 at 2:40 am
You say that the users are a member of an existing group. Do you mean that they are a member of an NT Security Group? If so add...
August 5, 2003 at 2:59 am
If the users are all logging in as 'sa' then you will not by default be able to tell them apart. Also using the 'sa' account in this way...
July 31, 2003 at 2:21 am
If you write zero to a datetime it will be represented as 1/1/1900, so something like this may be what is occurring.
Try forcing the blank to be null, for example...
July 31, 2003 at 2:04 am
You can do it all in one - just put two single quotes instead of one. e.g.
@sqlquery = 'SELECT ErrorMsg FROM ErrorTable WHERE ErrorMsg LIKE ''Critical%'' '
July 23, 2003 at 1:52 am
This is my CDOSYS (Win 2000 Server/SQL 2000) mail routine, which is originally from Microsoft's MSDN. There is also a script in the SQL Server Central script library which...
July 14, 2003 at 7:18 am
Sorry, I meant can you ping the SMTP server?
July 14, 2003 at 7:03 am
Try:
if (dob IS NULL)
BEGIN
insert
from [tablename]
END
else
BEGIN
insert * from [tablename]
END
Although in this case you don't need the BEGIN and END and there...
July 14, 2003 at 3:00 am
I get this message when I take a database off-line and then access a login's properties. (My development server is a very basic machine and this can help to conserve...
July 14, 2003 at 2:52 am
Viewing 15 posts - 61 through 75 (of 89 total)