What is the keyboard shortcut for entering a <NULL> into a database field from within the Enterprise Manager? I've done it before, but can't remember it for the life of me! Also, is there a query that I can use to insert <NULL> in place of ''?Run...as fast as you can ...away from EM...
Just don't put anything in there....
EDIT: It's [CTRL]+0|||Originally posted by Brett Kaiser
It's [CTRL]+0 Thanks!|||Now do yourself a favor and stop using EM and start using QA|||I'm a SQL newbie ... forgive my ignorance. I find it easier to use EM since it's graphical and I can enter/edit information on screen vs. writing queries. Since this DB is in development, this doesn't pose any locking issues.|||Well, if you learn to do it right while you're developing, when you go to production you will have a set of tools for troubleshooting data that you will find yourself going to EM to do otherwise.
You really shouldn't use EM ever for any reason. We continually tell people that because basically the tool sucks. :)
Showing posts with label shortcut. Show all posts
Showing posts with label shortcut. Show all posts
Sunday, February 19, 2012
Friday, February 17, 2012
Enterprise Manager
Hi,
My Question is regarding the Query Analyzer.
When we click on the Query Analyzer Shortcut, it will prompt for a user id and password.but when we expand the databases node from EM and clicks on Tools->Query Analyzer Menu, after selecting a database node, the QA does not prompt for the user id and password. Can any one explain this behaviour of QA..
I am using Mixed mode authentication for my db server.Enterprise Mangler launches QA using the same credentials used for the database connection being used by Enterprise Mangler.
-PatP|||could you please elaborate..|||'Enterprise Mangler'... nice :)
In order to have access to a database through the EM, you first have to register that server - selecting the server name, login name and password to establish a connection.
When you launch QA through the EM, you are doing it through an already established connection, the login & password are already there.
A simplified explanation, theres probably a more technical one than i would be able to provide, but it should give you a basic answer to what you're asking.|||could you please elaborate..
When you register a database in Enterprise Manager, you have to enter in the credentials you wish to use. If you right click on the server node (in EM) and select Edit SQL Server Registration Properties, you will see the credentials you used to register the database.
When launching Query Analyzer (QA) from EM, QA simply re-uses these credentials.
I have seen posted somewhere code that will hack your registry to find the username and passwords for all the nodes in your EM console. Just something to think about.
Regards,
hmscott|||When you expand the database node and launch Query Analyzer, Enterprise Manager assumes you want to run a query on the server and in the database you have selected (expanded). Without selecting/expanding a database in Enterprise Manager, it has no idea what server and database you want to use, so it has to prompt you.|||Thank you very much... :)
My Question is regarding the Query Analyzer.
When we click on the Query Analyzer Shortcut, it will prompt for a user id and password.but when we expand the databases node from EM and clicks on Tools->Query Analyzer Menu, after selecting a database node, the QA does not prompt for the user id and password. Can any one explain this behaviour of QA..
I am using Mixed mode authentication for my db server.Enterprise Mangler launches QA using the same credentials used for the database connection being used by Enterprise Mangler.
-PatP|||could you please elaborate..|||'Enterprise Mangler'... nice :)
In order to have access to a database through the EM, you first have to register that server - selecting the server name, login name and password to establish a connection.
When you launch QA through the EM, you are doing it through an already established connection, the login & password are already there.
A simplified explanation, theres probably a more technical one than i would be able to provide, but it should give you a basic answer to what you're asking.|||could you please elaborate..
When you register a database in Enterprise Manager, you have to enter in the credentials you wish to use. If you right click on the server node (in EM) and select Edit SQL Server Registration Properties, you will see the credentials you used to register the database.
When launching Query Analyzer (QA) from EM, QA simply re-uses these credentials.
I have seen posted somewhere code that will hack your registry to find the username and passwords for all the nodes in your EM console. Just something to think about.
Regards,
hmscott|||When you expand the database node and launch Query Analyzer, Enterprise Manager assumes you want to run a query on the server and in the database you have selected (expanded). Without selecting/expanding a database in Enterprise Manager, it has no idea what server and database you want to use, so it has to prompt you.|||Thank you very much... :)
Subscribe to:
Posts (Atom)