Copyright © 2008-2016 Paula DiTallo

Tag Cloud

March 2013 Entries

SQL Server: I need to get to a remote server and management studio is broken. How can I login without ssms?

Try using osql . It can be a life saver. Here's an example of the most common usage:osql -E -S myMSSQLServerName /* This uses windows authentication to connect to a server */osql -? /* lists all the switches available to use with osql */Once you see the SQL prompt (1> ) , you can interact with the server.1> USE myDatabaseName2> GO3> SELECT col1, col24> FROM myTable5> GO6> 7> EXIT Here's a link or two to get you started. ......

SQL Server: Is there a query I can use that generates similar output to Activity Monitor?

Yes! This query will return very similar information to what activity monitor returns--including the text of the query the process is running (when applicable). -- Query version of Activity Monitor SELECT SessionId = s.session_id, UserProcess = CONVERT(CHAR(1), s.is_user_process), LoginInfo = s.login_name, DbInstance = ISNULL(db_name(r.database_id), N''), TaskState = ISNULL(t.task_state, N''), Command = ISNULL(r.command, N''), App = ISNULL(s.program_name, N''), WaitTime_ms = ISNULL(w.wait_duration_ms, ......

SQL Server Agent:: I Can't Edit a Job Step because of the error "Creating an instance of the COM component with CLSID from the IClassFactory failed"

The immediate workaround to this problem is to open up a new SSMS session, then navigate to the SQL Agent Job you want to edit. At that point, you will be able to make the edit and save the changes.For more information on why this error occurs and the possible release(s) fixes, check out this url:http://connect.microsof... ......

SSIS: I get the error The column data for column "Column x" overflowed the disk I/O buffer

If you are reading a flat file, you are missing a delimiter somewhere and SSIS is trying to parse for the next value--so it thows an i/o buffer error. Look in the file for the missing delimiter. If the file is too big for that, try chopping up the file up into smaller versions until you find the line with the missing delimiter.

Eclipse Project:: How do I add an external *.jar file to my project?

1. Navigate to the project. Right-click, go to the Properties menu.
2. Go to the Java Build Path. Choose Libraries. Click the Add External JARs button.
3. Select the jar file/library to add.

NOTE: For projects you own, that you would like to add, use the Add JARs button instead.

Visio 2010: How do I change the Title when in Borders & Titles?

To edit the text in a title or border in Visio 2010:

1. Look at the bottom of the document, click on the tab for background page  (usually called: VBackground-1)

2. Navigate the shape that has the text you want to change; type in the new text.

Visio 2010: How do I change the relationship arrows in the database diagram?

For a quick changeover, go to:

Home -> Database -> Display Options ->Relationship

Select the relationship, then Database Properties -> Miscellaneous.

SQL Server 2012: How do I set "Edit top" rows to a different number?

right click the results or your "Edit Top 999 Rows" query in SSMS. There's an option called: "Pane -> SQL" If you look at it, this show you the sql--you can edit that and narrow down the rows you are interested in editing even further.