Search results for query: *

...INTO #results SELECT 'Step 2 - ' + @fullname + ' ERROR:' + ERROR_MESSAGE() END CATCH WORKS OKAY EXEC sp_changeobjectowner @fullname,'dbo' /* INSERT INTO #results SELECT 'Step 2 - ' + @fullname + ' ERROR:' + ERROR_MESSAGE() */ After running this, I can no longer see the tables in...

...to acheive this? DECLARE @dbusername VARCHAR(255) DECLARE @tablename VARCHAR(255) DECLARE @fullname VARCHAR(255) SET @dbusername = 'notdbo' /* Get all tables with that username */ IF OBJECT_ID('tempdb..#tables') IS NOT NULL DROP TABLE #tables IF OBJECT_ID('tempdb..#results') IS NOT...

None of these things worked ... including a complete uninstall and install. After extensive searching i found the resolution: Outoook Help > Detect and Repair Make sure 'Discard my Customized settings and restore default settings' is selected. Weird .... The early bird gets the worm, but...

Alt+F11 does nothing in Outook 2003, nor does Tools > Macros and any of the options (Security, Macors, VBE). It works as normal in other Office 2003 apps. Is this something I need to beat up my network admin about? Is it a registry tweak? TIA The early bird gets the worm, but the second...

OK I figured it out .. it's Set xlRng = Rows(iStartRow & ":" & iEndRow) Thanks The early bird gets the worm, but the second mouse gets the cheese.

What's the easiest way to set a range to variable rows? Rather than: Set xlRng = Rows("1:4") I need it to be dynamic: iStartRow = 1 iEndRow = 4 Set xlRng = Rows(iStartRow:iEndRow) Thanks! The early bird gets the worm, but the second mouse gets the cheese.

Updating this thread, all of the reports will work or not work. All of the clients can see the reports, that for some reason all of the clients will get the error message regardless of the report ... until we restart the web server. The early bird gets the worm, but the second mouse gets the...

Once the error starts occurring, I can run reports that have previously worked with the same selection criteria that now display this error. Unless running a report with no results actually causes the entire Crystal Enterprise web service to crash and force a reboot than this can not be the...

More info..... Microsoft VBScript runtime error '800a01fb' An exception occurred: 'objCrystal.OpenReport' /Crystal9.asp, line 185 The early bird gets the worm, but the second mouse gets the cheese.

Similar to thread782-965562 , I'm using IIS 6.0, Windows 2003 SP1, and CE version 9 (a limitation of our application.) Everything else is fine, but once the first report comes back 'Page Not Found' then the only way to get CE back up is restarting. Our software vendor hasn't been much help...

This is the relevant part of my code that creates the button and action: Set oVal = oOpt.Controls.Add(Type:=msoControlButton) oVal.Visible = True oVal.Caption = oRS.Fields("schName").Value oVal.OnAction = "LoadReport(""" & oRS.Fields("schName").Value & """)"...

So SQLSister, you single? ha ha ha. Been looking to write a 'UNION ALL' query ;-). Of course we would both need to have the same columns and data 'types'. Thanks for the detail, johnherman. This thread has been a little lacking. Maybe that explains Oracle's outperforming of MS SQL in the...

Yeah I had a big discussion with their sales force and some of their engineers. They indicated it was their [MS] long term stategy to keep them seperate, and even provided documentation to support that. Never know though .... The early bird gets the worm, but the second mouse gets the cheese.

I just bought 20 Proclarity licenses (I evaluated 12 different Analysis Services clients) for end users. They are loving it! No more waiting for 2 weeks for a report analyst. The early bird gets the worm, but the second mouse gets the cheese.

Being in a SQL Server programming forum I think we all realize that. No, in my current job there's no way I would want to code all of my DTS packages, migrate the OLAP to third party vendors (just Cognos alone would outprice SQL Server I believe), etc. It's all possible for a price of course...

Or just do it all from an ActiveX script job. The early bird gets the worm, but the second mouse gets the cheese.

Honestly depending on the size of your operation, I think there's more of a trend to switch to MySQL (now that they have Stored Procedures). I mean ... for $0 and with much of the functionality of SQL Server. Of course companies feel as though 'nothing comes for free' so they are hesitant to...

You could also use a DTS package to do this, but I think a stored procedure would be easier if you are not proficient in VBScript. If your data is already in SQL server, there's no reason to involve other systems. DTS Package runs every 45 minutes Task 1 ... Execute SQL script Calls stored...

Well when evaluating the expression, it will become: (' '1','2','3','A','B','C' ') So only a match for that entire string will be excluded. If it is always 6 then it will simply be a matter of using 6 variables. If the number varies, you may need dynamic SQL or another workaround (such as a...

...use Global Variables to hold anything that may potentially change or be scalable, such as paths and filenames, but you can just hard code these. '********************************************************************** ' Visual Basic ActiveX Script...