| FAQ |
Q: How can I create tables, indexes or triggers? A: SQLExecMS does not have any wizards. So the only way to
create any objects is just using Query window and type DDL statement into it. Q: How can I find object by it's ID? A: Connect to your database, open Objects
properties window. Type ID into Find edit box and use Search
by ID item from drop down menu of Find button. Q: Sometimes I get and an error "Cannot find object's DDL". A: It can happen with triggers and indexes. For performance
sake, SQLExecMS does not load them when it builds the tree of database objects right
after you connected to a server. They will be load on demand, if you try to expand
triggers or indexes group in that tree. Q: I want to create a local copy of an assembly on my local drive, how can I do it? (SQL 2005 only) A: Select desired assembly in "Database Objects" and choose
"Object's properties" from context menu. In appeared dialog select a file
and click "Import file" button.
Q: Why Space utilization window shows negative numbers for some tables in "Unused" column? A: SQLExecMS relies on information in sysindexes table .
There are some situations when the sysindexes information for the table may not be
current. Use "Update space usage..." button to correct this inaccuracy. Q: How to check selectivity of the index? A: Open Indexes window, Select desired
index, Use "Show statistic for selected index" button. If an
index is marked with an exclamation sight, that means that
the density of the index is low. The bottom panel will show
selectivity of a set of index column prefixes.
Q: I need to run sqlmaint utility as part of my job but not maintenance plan, how can I configure the parameters? A: Open Maintenance plans window and press New
Plan button. In appeared New Plan window create new job and
select all actions you want sqlmaint to perform. When you
finished with configuration, copy the a text from Step text
edit box, here you'll find all parameters for running
sqlmaint, with one exception: you will need to substitute
PlanID parameter by the -S, -U, -P, D switches, which will
tell sqlmaint how to connect to the server. Check BOL for
details.
Q: I moved my database on another SQL server by
detaching/attaching it, and some DB users became not usable.
How can I fix it? Q: I want to create new user in a database with exactly the same permissions as existing one, how can I do it?
A: Open "Users" window, go to "Users" tab.
Select "Add.." item from context menu.
In appeared dialog fill out all the fields as for new user,
check "Create a copy of Existing User" and select a user
from drop down list, which copy you want to create. Q: I want to move an object from schema to another, how can I do it? (SQL 2005 only) A: Open "Users" window, go to "Schemas" tab. Select source schema, find object in the right panel and drag and drop it to the target schema
Q: DataView window does not sort the data the way I want or shows error "tblMain: Field 'XXXXXX desc' not found". A:
There are two ways to sort the data in that window. Q: Why I cannot see the result of PRINT and some DBCC commands? A: SQLExecMS does not support PRINT command. Since some DBCC commands use the same technique as PRINT, they are not supported also. Q: How can I export output of my SELECT statement into XLS file from Query window? A: Select all rows returned by your query (or any range of
them) and use 'Save selection as ...' item from popup menu of the grid. Pick the format by
selecting proper extension for a file. A: SQLExecMS supports aliases for that purpose. Once
connected to the server simply click on "Add to alias list" button in Connect
window, give your alias name and later you can connect to your server by selecting that
alias form a list. Another way is to use "Get available SQL Servers" button on
the same window.
|