Search results for query: *

I'm not sure about Oracle, but refreshing with SQL Server/Access doesn't always update the report with new fields. The option I use is "Verify Database"... With luck a message like "Object X has changed, proceed to fix up report?" should appear... Just click ok. Chris

I've come across the problem before. The way I solved it was to use the "DayOfWeek" option... This returns a number for the day of the week (1 for Sunday, 2 for Monday, etc.)... Now subtract the numbers of days away from your date (If Monday subtract 0, Tuesday, subtract 1, Weds...

Paula, An added hint regarding CR & SQL 7. Not sure which version of Crystal you use... but in Version 5 + Upwards there is an option to "Show SQL Query" (Under CR Version 7 it's under the Database menu). This option will display the SQL "SELECT" statement that Crystal...

Sorry for the delay in writing back. It shouldn't be - SA is a member of Sysadmins, which means it can do pretty much whatever it likes. If you want to try it out, change the dbowner back to SA (sp_changedbowner - look in Books on-line for more info.) perform the upgrade & then switch it back...

Suggest you open Query Analyzer & execute: sp_helpdb on the master database. This will tell you the current state of all databases in the system, and should point you in the direction of the one that is failing. Once isolated, the database properties can be changed through Enterprise Mgr...

Are you checking C:\Region.txt on your server, or workstation? Running the exec statement within Query analyser will copy the file down to your local C: drive, but execution through a trigger will always copy down to the C: drive of the server that you are using.

John, The best bet is probably to use Backup/Restore. From SQL EM, Take "Backup Database", and backup the database to a file (simply specify a detination file to send the DB to). After backing up, ZIP the file, and with a bit of luck it will fit onto a diskette. When restoring the...

John, Should be easy enough to resolve, just scroll to the end of the table in Enterprise Mgr, and then return back to the point where you want to edit the data. SQL EM can only modify the lines when it's read all the records... A "Firehose Cursor" is just the method that it uses to...