Viewing 15 posts - 946 through 960 (of 1,065 total)
Try making the Where clause:-
WHERE UPPER(STREETNAME) <> STREETNAME
June 24, 2003 at 1:35 am
If your database was in 'Full' recovery mode, then your transaction log may well contain all of your transactions.
You might then be able to resurrect a lot of the data...
June 23, 2003 at 4:59 am
stax68
You're right, the query was considerably more complex than this.
It happened a while ago, so I don't know if I will be able to find the details. If I do,...
June 20, 2003 at 1:36 am
Steve
Beware of using your method, I have seen a case where that didn't work.
I had 2 very similar queries, one worked, the other didn't. When I examined the query...
June 19, 2003 at 10:31 am
You won't get a clustered index seek on your where clause because of the functions operating against the table columns. e.g. upper(Chapter).
If you have your SQL Server collation configured as...
June 17, 2003 at 9:54 am
ODBC will only list those databases that your Userid has permissions for.
Check in Enterprise manager to see if your UserId has permissions to the missing databases.
June 16, 2003 at 1:45 am
Try running the BCP command that your code generates in a Command Prompt.
June 13, 2003 at 1:34 am
Have a look at Knowledgebase article 812915.
We ran into this bug as soon as we installed SP3.
June 13, 2003 at 1:29 am
Just because the database is only used by one application, doesn't mean a 'numpty' (or a DBA) couldn't use the likes of Query Analyser to delete a crucial record.
If there...
June 12, 2003 at 3:30 am
Your proposed solution will not work, because the DELETED table is only a psuedo table available to the trigger. Your BCP will start using another thread and will not have...
June 12, 2003 at 1:34 am
Your best bet would be to execute your VB Application or VBScript via xp_cmdshell.
You could then use SQL Agent to schedule the executions of the xp_cmdshell script
June 10, 2003 at 3:26 am
You could run the BACKUP DATABASE command in a sql script using ISQL with the -S option to specify the name of the server to run the script on.
June 6, 2003 at 8:01 am
The stored proc sp_spaceused uses the values taken from the sysindexes system table.
The values in sysindexes are not guaranteed to be accurate, as some bulk operations don't correctly update them.
...
June 6, 2003 at 1:11 am
DBCC INPUTBUFFER(spid)
This only gets the first 255 characters of the command.
SP3 introduced the fn_get_sql function (see the updated SP3 BOL for details), which returns the information in a text column.
...
June 5, 2003 at 5:13 am
Log Shipping happily exists alongside full backups.
Although the full backup also backs up part of the transaction log, the integrity of the transaction log backups is maintained.
Therefore, if you do...
June 5, 2003 at 3:49 am
Viewing 15 posts - 946 through 960 (of 1,065 total)