Search results

I just installed the shiny new MSSQL server 2008 standard (MAPS) on my production machine and low and behold, I could no longer see any databases on MSSQL5, which I previously had access to in the beta "Katami" version of MSSQL 2008. After a bit of research I found the following solution...

Go to connect > database engine. In the resulting dialogue box, click the "options" button. On the "Connection Properties" tab, enter the database name in the field adjacent to the text, "Connect to database".

I'm assuming that you're using VBscript. Since classic ASP/VB does not support UTC, the best way is to use MSSQL. This first bit will set up a recordset which calls the UTC date and time, adjusted to Mumbai (UTC/GMT + 5.3 hours). Be sure to change the cmd.ActiveConnection value: <% Dim...

No, but unless you use parameterized queries, your applications will be subject to SQL injection attacks.

You need to be sure that all SQL commands are parameterized. You'll need to check every file in every site. No way around it. Adobe Dreamweaver CS3 does a nice job of parameterizing legacy code written in previous copies of DW semi-automatically; for hand-written code, it will all need to be...

As in no more MSSQL? I hope and pray that Jodohost does not take this drastic step, as that would spell disaster for us...

Yup, happy birthday to the best Windows Operations Manager one could every hope for!

The interesting bit is that ANY query that has non-parameterized variables is a vector for this exploit. You can sanitize inputs all you like (even regular expressions restricting to integers) and it will make no difference.

The same method as used successfully for table permissions: In MSSQL Server Management Studio: Right click on stored procedure, go to properties, Click on permissions, click "add", add the user, set the permissions. These are not system stored procedures, as I said:

Holy thread resurection! On a different/more contemporary note: When using stored procedures on MSSQL2005, the only stored procedures that have permissions to execute are those created within the schema of the dbo. When attempting to add permissions to a given procedure in EM, all seems to...

ipconfig /flushdns

All fixed. Thanks, Tanmaya. You're the best :) Could you please close all open tickets in my account? All of these issues have been resolved.

PM sent. whatever. This is the same name that I've been using for 3 years with no problems. Furthermore, it's the name that Jodohost staff insisted I use during a protracted argument on this very issue back in 2005. The fact of the matter remains, that no matter what user name I employ...

Tanmaya PM'd with URL and username.

When tickets are submitted to Jodohost via the ticket system, they no longer show up in the ticket history. Ever. Furthermore, I've submitted two tickets, #s JKR-44512-624 and BPT-61741-973 respectively, neither of which has been replied to. The first has been in the system for 20 hours, the...

The entire object explorer view of the database is blocked, regardless of login parameters. The only workaround I've found is to set up a single user as "DB admin", submit a ticket to have that one user be given permissions to view the object explorer and then use that one user to create all...

Hey, Pratik Please see response in this thread.

down again...all day this time...Taking this to the customer only area

And I just replied back; Let's see if this can be figured out via ticket and if not, perhaps I'll revive the forum version of this discussion in the customer-only area.

Down again! What do we need to do to fix this!!! X( X( X( :frusty: :frusty: :frusty: :mad2: :mad2: :mad2: