Search results for query: *

I actually need the script to only change one schema to dbo (this is a SQL Server 2000 upgrade to 2008 issue) Well the issue is here: CRASHES SERVER UNTIL PROCESS KILLED BEGIN TRY EXEC sp_changeobjectowner @fullname,'dbo' END TRY BEGIN CATCH INSERT INTO #results SELECT 'Step 2 - ' +...

I wrote this little script to change all of a schema's tables to 'dbo' but when it runs into a table that already has a 'dbo' version, it locks up my entire database until I kill the process. Is there an easier way to acheive this? DECLARE @dbusername VARCHAR(255) DECLARE @tablename...

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...

Well you would start with a SQL Server Connection and an excel connection to your template file. Then create a 'Transform Data Task' between the two of them. Right clicking that task and choosing properties will display the 'source' tab. Change the connection from Table/View to SQL query...