...bringing you notes from the field...
Answers to problems/questions across all topics.
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. http://msdn.microsoft.com/e... ......
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, ......
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... ......
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.
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.
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.
For a quick changeover, go to:
Home -> Database -> Display Options ->Relationship
Select the relationship, then Database Properties -> Miscellaneous.
The full error in Microsoft Visual Studio on a compile looks like this: error CS1548: Cryptographic failure while signing assembly 'C:\Program Files\Microsoft SQL Server\100\Samples\Analysis Services\Programmability\AM... This is likely due to a missing strong key pair value file. The easiest way to solve this problem is to create a new one. Navigate to: Microsoft Visual Studio 2010>Visual Studio Tools>Visual Studio x64 Win64 ......
If you are on a desktop version of Ubuntu, you can right-click on the file icon, click the permissions tab and click on "allow execution". If you are on a server copy without the desktop bells and whistles (or you would rather work with a command line in a terminal window), then do the following: sudo chmod +x myProgram.bin after you enter your password and get the prompt back type: ./myProgram.bin ......
Normal 0 false false false EN-US X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans... mso-ascii-font-family:Calibri; ......
For a full explanation and step-by-step guide to setup a linked server through Sql Management Studio (SMS), check out this reference: http://www.databasejournal.... Here it is in a nutshell: If you are setting up a linked server for another sql server 2005/2008 box, just remember to (1) name the Linked server the same name as its network name, (2) select and provide under the security option ,"Be made ......
I've been there! You are at a client site and you know you need certain data elements but aren't certain how many databases on a given server ...or ... which tables the data elements you are interested in might appear. Here's a single statement when executed from any SMS query connection that will get you there: EXEC sp_msforeachdb ' DECLARE @pattern nvarchar(100) SET @pattern = ''%elementName%'' IF EXISTS(SELECT 1 FROM [?].information_schema.columns WHERE column_name LIKE @pattern) BEGIN SELECT ......
You have at least 2 choices: Source 1: SQL Server 2008 Feature Pack http://www.microsoft.com/do... ... this includes Microsoft OLEDB Provider for DB2 Source 2: Available from IBM, is the IBM I Access pack http://www-03.ibm.com/syste... Remember, whichever one you use, you will need to specifiy which libraries under the detail/advance settings in ODBC ......
That is a very good question..to which only Microsoft has the answer!:-) In the meantime, suffice it to say that every once in awhile, Visio loses track of your Glue/SnapTo settings which you'll need to restore. Here's what to do: 1. In Visio, navigate to "Home", open "View", expand "Visual Aids"2. Once in "Visual Aids", Check or Re-Check the "Glue"box. 3. Under the "Snap To" category, be sure shape intersections, shape handles, shape vertices, and connection points are all checked. 4. Under the ......
The last thing anyone wants to do is mess up an UPDATE statement! Here's a quick refresher for those of you using SQL Server: Simplest case (a single row, in a single table with a single known value in a column): UPDATE YourTableName SET Column1 = ‘NewValue’ WHERE SameOrOtherColumn = ‘OldValue’ Most common case (multiple rows, using another table as the source data with multiple columns): UPDATE YourTableName SET ColumnX = OtherTable.Column1, ColumnY = OtherTable.Column2 FROM OtherTable WHERE YourTableName.Column1 ......
To quickly look through your stored procedure objects for a text value in a database instance, do the following: use [Metro] go SELECT ROUTINE_NAME FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION LIKE '%whatyouarelookingfor%' AND ROUTINE_TYPE = 'PROCEDURE' Now, this is no replacement for a configuration management repository, but it will do in a pinch. BTW, remember this sql statement does NOT transcend all databases on the server, just a single db instance ......
If you're like me, you've probably clicked/clacked, docked/undocked the window with the edmx file while you were working on it in visual studio without intending to--and now, the entity diagram is gone and you are unable to open the file again from the solution window! Luckily, the edmx file is just another visually displayed xml file. From the solution window, right click on the edmx file -- select "Open with..." -- choose Xml . Once you see the xml for the edmx file close it. Go back to the solution ......
The chances are pretty high that you are creating a multi-tiered application with a solution that may be calling several different projects, one of which is the ADO.NET Entity Framework DAO-layer. In order for the entity frame work to work outside the immediate project that its been created under, you'll have to import the connection string built by the EF wizard at create time to your other project's application or web config file. Here's an example. I have two projects under a single solution, ......
Yes, Microsoft is getting quite a reputation for abandoning or deprecating it's data access products/libraries. One thing you can do is download a 3rd party product called dotConnect by DevArt. The express edition is free. http://www.devart.com/dotco... ... however, if you are working in a shop that doesn't like its development team to use not well known third party tools, there's an alternative--but it still requires that you go to a non-microsoft source. Use Oracle.DataAccess.dll ......
Vista has an auto tuning feature which is hit and miss, depending on what network appliances/cards/devices you've got hooked up. Try this: 1. Navigate to Start>Programs>Access... Command 2. Type: netsh interface tcp show global 3. Look the line for receive window auto tuning. If it says highlyrestricted type this command (all on one line): netsh interface tcp set global autotuning=restricted 4. Try browsing, if it isn't any better, enter the same command like, just change restricted ......
Ten minutes ago I created a scratch db instance with a name I mistyped. Not good! Fortunately, I have admin privileges so I can change it in my lab environment. If you're an admin AND no other users are accessing the DB instance, here's what you can do: USE master go EXEC sp_renamedb 'MetroWrongName', 'MetroRightName' GO If someone is using the instance, there is a workaround. Do this: USE master go -- flag the instance for single user only EXEC sp_dboption 'MetroWrongName','Single User', True GO ......
The worst part about web application development is the phase in the unit testing where we developers swear we've fixed something, but still when we test the change, the fix isn't there. After awhile, we remember to clear the browser cache and we discover the fix worked! In some cases, we really haven't fixed what we thought we fixed--and in other cases, we haven't really cleared the cache. I was working in FireFox recently and realized I hadn't really cleared the cache when I added a new button ......
This one will order the contraints by table: Select SysObjects.[Name] As [Contraint Name] ,Tab.[Name] as [Table Name],Col.[Name] As [Column Name] From SysObjects Inner Join (Select [Name],[ID] From SysObjects Where XType = 'U') As Tab On Tab.[ID] = Sysobjects.[Parent_Obj] Inner Join sysconstraints On sysconstraints.Constid = Sysobjects.[ID] Inner Join SysColumns Col On Col.[ColID] = sysconstraints.[ColID] And Col.[ID] = Tab.[ID] order by Tab.[Name] This one will order the contraints by column: Select ......
The easiest way in MS SQL 2005 and up is to use the SQL Management Studio, go to Views, highlight the name of the view you are interested in, right click, select Script View as/Create to/Clipboard. open up notepad or your prefered editor and paste the contents of your clipboard. The SQL used to create the view should show up in your editor. If this doesn't work, or if you are working with older versions of SQL Server, look at the system objects as follows: use [YouDatabseInstanceName] go select * ......
Before I create views, I generally work out what I want to retrieve in my SELECT statement ahead of time so I'll just have to cut and paste the query. The example below is done in T-SQL/Sybase format, however for Oracle and MySQL, just place a semi-colon ';' at the end of your statement and remove the 'GO' command. To drop (delete) an existing view: DROP VIEW vw_rpt_metroBestCustomers GO To create a view: CREATE VIEW vw_rpt_metroBestCustomers ( CustomerName, OfficeNum, City, StateOrProv, Country, ......
Here is the quick answer: Go into your client e software (e.g. Outlook, Thunderbird, etc.) for the account you are working on (usually default). Set the SMTP server to smtp.gmail.com Set the username as your gmail account user name (e.g. myname@gmail.com). Gmail will need the username and password you use for that account, so if your default is set to some other email, be sure to set the username and password to that value, or click on the checkbox for username/password. Check TLS as the secure connection. ......
I've encountered a LOT of posts on this--some of them represent a LOT of unnecessary work. Here's the simple way: 1. Navigate to Administrative Tools. 2. Go to Internet Information Services (IIS) 3. If you last looked at something, Navigate to ABOVE your server name -- where it says "Internet Information Services" 4. Look to the right. You should see something that looks like this: computer local version -------------------------- ------- ------------- YourComputerName yes IIS V6.0 You're DONE ......
The sys.tables and sys.columns objects will return this information for you. The following SQL statement will bring bring back all the colunns in all the tables ordered by the table name then the column name. SELECT tbl.name AS table_name, SCHEMA_NAME (schema_id) AS schema_name, col .name AS column_name FROM sys.tables AS tbl INNER JOIN sys.columns col ON tbl.OBJECT_ID = col.OBJECT_ID ORDER BY schema_name, table_name; ......
The objects that help you find this info in SQL Server are in sys.tables and sys.columns SELECT tbl.name AS table_name, SCHEMA_NAME(schema_id) AS schema_name, col.name AS column_name FROM sys.tables AS tbl INNER JOIN sys.columns col ON tbl.OBJECT_ID = col.OBJECT_ID WHERE col.name LIKE '%YourColumnNameHere%' ORDER BY schema_name, table_name; This will bring back every table that has a reference to '%YourColumnNameHere%' ......
Please do NOT edit the registry without backing it up first, the results could be disasterous! Step 1: Back up the registry in Windows XP as follows: a. Go to Start>Run then type %SystemRoot%\system32\resto... Click OK. b. On the System Restore page, click "Create a restore point". Click Next . c. On the Create a Restore Point page, type a name for the restore point you will remember. Click Create d. Once created, click Close. NOTE: If the restore is turned off, you will see a message ......
If you don't have the Visual Studio IDE to work with, you can go the old fashioned route with issuing PRINT statements. If you do have the Visual Studio IDE available, execute the following steps: open visual studio navigate to server explorer create/open a connection to your database right click on the stored proc you want to work with and choose "Step into stored procedure" For more details, or for a more visual example with the instructions, navigate to this url: http://www.dotnetfunda.com/... ......
If you are working with enum types, you were probably trying to assign something like an input string to the constants you defined as an enum type earlier. let's say you created an enum type called PoliticianType enum PoliticianType { knownothing = 1000, whig = 1010, federalist = 1020, republican = 1030, democrat = 1040 } ...and you had a console app that was accepting user input from a readline statement: Console.Write("Which political party? (press CTRL+Z to exit): "); string political_party = ......
For Sun Virtual Box:
use the Right-Ctrl (read: the ctrl key on the right side of your keyboard).
For VM Player:
ctrl + alt
The eznwupd.exe program is an update program for the greater spyware program called eznorun.exe. To get rid of this menace, do the following: Go to c:\Program Files\ezn. Delete the directory. Empty the trash to actually remove it. Go to run at the start menu and type: regedit. Search for and remove all keys, values, etc. to eznorun.exe Go to to run at the start menu and type: msconfig. Go to the Startup tab. Delete the eznorum.exe entry. That should do it! You should no longer see this message appearing ......
There's more than one reason why you may receive this error, but the most common reason is that your order by statement column list doesn't correlate with your intended column-to-retrieve list when you happen to be using DISTINCT. This is usually easy to spot. A more obscure reason may be that you are using a function around one of the selected columns --but omitting to use the same function around the same selected column name in the order by statement. Here's an example: select distinct upper(columnA) ......
This should work for SQL Server 2005/2008-- ALTER SCHEMA SchemaNameForTarget TRANSFER SchemaNameOfSource.MyTableName example: ALTER SCHEMA RiskEvaluation TRANSFER dbo.ConvertibleDebenture ......
Here are the 2 common patterns in .NET: GIVEN: PATTERN #1: Note: this method will work with collections that are typed, but not necessarily defined in a class which manages enumeration string itemName; for (int index = 0; index < OrderList.Count;index++) { itemName = OrderList[index].ItemName; // do stuff here } PATTERN #2 using System; using System.Collections.Generic; using System.Text; namespace AskPaulaExamples { public class Whine { // define AND dub the collection with something List<string> ......
If you're getting this message: The type 'System.Data.Linq.DataContext' is defined in an assembly that is not referenced. You must add a reference to assembly 'System.Data.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b77a5c561934... C:\Documents and Settings\pldital\My Documents\Visual Studio 2008\Projects\PatentableSer... ... add... System.Data.Linq as a reference to your project. I still get bit every once in awhile (read: pasting together a poc) ......
usually your host file (DNS/ip addresses) can be found under:
c:\windows\system32\drivers\etc
This can be a really irritating problem when suddenly the EXCEL file on your desktop you used to double-click on no longer gets viewed via Microsoft EXCEL, but instead gets viewed through the Microsoft Excel READER program instead! In essence, either a new program you've installed has reset the file association, or you are working on a new computer that may have different software--overall, this area has to do with File Management/File Extension types. Here's what to do: In Windows XP: 1. Look for ......
In a nutshell, this is a FireFox last release issue. If Internet Explorer is not your default browser, go into the internet options page (under the gear icon in IE 7) , then go to the programs tab. Click on the 'Make Default' button, then 'Apply'. Try clicking on the link from your email message again. The message should now be gone. Raymond @ www.raymond.cc has a GREAT detailed blog entry on this issue explaining all of the reasons and conditions. http://www.raymond.cc/blog/... ......
When this dreaded error crops up, its usually right in the midst of a fast and furious development effort. That's always been the case for me! To solve it in a hurry, I just dub the app with a higher version number, recompile and move on--at least that is what I did when I was a bts developer. Now that I'm a bts admin, I've delved into the topic more. Although the re-versioning scenario works, it is possible to re-deploy an *.msi package with the same version number using these few steps: Go to \Documents ......
Perhaps you've experienced the scenario where you hit the F5 key on the Group Overview in the BizTalk Admin console and instead of seeing your message queues, you see instead the very ugly () message: Failed to create a CLSID_BizTalkPropertyBagFac... COM component installed with a BizTalk server. A dynamic link library (DLL) initialization routine failed. (WinMgmt) Go to the event viewer and look for any COM/COM+ errors under applications. Chances are you will see a conflict with WMI services--perhaps ......
The full error message looks like this: [SNAC] “[SQL Native Client]SQL Network Interfaces: The Local Security Authority cannot be contacted.[SQL Native Client]Cannot generate SSPI context” [MDAC] “Cannot generate SSPI context”; [.Net1.0/2.0]” Failed System.Data.SqlClient.SqlEx... Cannot generate SSPI context” When this message occurs--especially when the same access 20 minutes ago worked, chances are you've logged off of your primary network. An example would be that at work you were using an ......
For those of you working with LINUX/UNIX and you've typed:
c:> echo $PATH
..in a command line expecting to see everything in your path on startup and saw only 'PATH', don't fret! 
type this instead:
c:> echo %path%
If you are getting the message... This operation has been canceled due to restrictions in effect on this computer ...whenever you try to click on a hyperlink in a mail message when you are in Outlook or in a Word document, it is primarily because your default web browser has a 3rd-party setting that doesn't work and play well with Office products. For example if you are using the FireFox web browser, try changing the default web application to be Internet Explorer. To do this, follow these steps: ......
Remote Desktop is actually called mstsc.exe and can be found under: %SystemRoot%\system32 (Usually C:\Windows\system32.
I can't answer that question in detail, but I can say that on Windows 2003 servers under x64 you must explicitly set up IIS to Allow Web Service Extensions for ASP xxxxx (32) applications. In a console window, type: cscript %SYSTEMDRIVE%\adminscripts\... SET W3SVC/AppPools/Enable32bitA... 1 Then proceed with the following steps: Open IIS; Web Service Extensions Click on Allow All Web Service extensions for a specific application Choose ASP Net vX.Xxxxx (32) Click OK In a command window ......
On your keyboard you'll see the function 8 key (F8). This is the key that controls flip-flopping between lcd/crt. You'll also see another key near the control key [Ctrl] called FN. FN is the function key. Try this key sequence to invoke the second/external monior: FN + F8 (click these at the same time). This should wake up the monitor ......
You may need to map multiple web sites with the same port number or you may want to map an IP address that has been set to a netscaler vip/ip to multiple servers. IIS 6.0+ allows you to do that with a feature called Host Header Names. For the official details, review Microsoft's web site: http://support.microsoft.co... Here's how it works: Let's say you have a DNS entry called MetroDesignDev.LoadBalanced... @ ip address: 10.201.25.216 and one of the load balanced twins (ServerAlphaTwin) ......
Full Practical Answers Archive