I am having trouble setting up dbmail in SQL Server 2005 running on Server 2003. I am trying to send mail through an Exchange 2007 Server. Do I need to use the SQL Service account with Windows authentication? Also on the Exchange side, how should the "receive connector" be set? Software/Hardware...
Hello Members, I am very new to this blog.I want to need some information regarding VSTS2010 TFS(Team Foundation Server).I have couple of questions in my mind. I really want to share with you. At present time we want to implemnet automation testing...
Is there a way to "retrieve source" on a Stored Procedure ? I need to find out what 2 of our Stored Procedures do - especially what programs thay call. Of course, no documentation and no methodology for source-based creation. Software/Hardware used: as/400
How do I refresh reporting services fields after I have added new fields to my stored procedure? The new felds do not show up in Report Data window. I have tried rebuild and refresh. Neither sem to work. I am using SSRS 2008 Software/Hardware used: SSRS 2008
10. Using VRDP to view VirtualBox virtual machines remotely Rick Vanover has put together a useful tutorial for Sun’s xVM VirtualBox. 9. How to reset the Cisco Catalyst Switch to Factory Defaults Yasir Irfan offers some advice for those needing a fresh late on Catalyst switches. 8. Independent...
I have two tables -- [em]Users[/em] and [em]UserAddress[/em] -- with 30 million records in each. Software/Hardware used: SQL Server
I want to run the Data Mining tool in SQL Server Analysis Services 2005, but I can only get to the processing stage: It hangs (NOT RESPONDING) when I try to go into the Mining Model Viewer. Could this be a PC or SQL config problem? How do I resolve this problem? Software/Hardware used:...
SQL Server Analysis Services, SSAS 2005, Data mining/analysis
Hi all(waves) noob here ( :) ) ( yes you might look down upon me) ( :( ) never the less....:) Quick question: Tables made so far: department values (depno,dname) course values values (courseno) How would I create a table eg "Table budgets"...with values of two budgets (£100 and £200) for...
Here are the 10 most watched questions on ITKE: There’s some great discussions going on. Go answer a question now and take your shot at winning a TV: 1. Problem installing Exchange 2007 Management Tools was posed by Labnuke99 and answered by Mshen. 2. What Event ID was asked by Newbiepeon and...
I have tried to install SQL Server 2005 on Windows 2008 64 bit SP2. I have installed SQL server 2005 and SQL server 2005 SP2, however only the SQL Server 2005 configuration tools appear. (Everything was selected to install) I have found these posts which have the same issue, but they are...
SQL Server 2005 (64-bit), SQL Server 2005, SQL Server installation
To export userschema in oracle, we can use expdp and impdp commands. Do we have any commands to export/ import userschema in SQL server 2005? Also, How to export all the tables to filesystem? Using SQL management server studio there is an option to export 1 table at a time to a file.
Hello, I have to tables, one with name CONTRACT, second AGENT IN table CONTRACT these data: ClientID ClientName ClientSurname ContractNR AgentID AGENT data: ClientID Sum ContractNR I need to select 10 agent's clients, who have a bigest sum. One agent have 100 clients, second only 2 or one...
hi! each time i try to update the captioned update it fails. i guess it has also caused my ooutlook to crash!!! pls help Software/Hardware used: vista ultimate + off. ent. 2007 with biz contact mgr.
I have a file of Part-no with the spend by Plant (or Location). A given Part-no may have multiple records for the different Plant Locations. I am trying to capture one record for each Part-no that included the Plant with the highest spend and what that amount is. I tried to do a summary query...
Hi everyone, My database table has a time field called [time], Data Type of "Numeric" length of "9" with a Precision of "14" a Scale of "0". The query below produces the following output : 2009-10-14 00:02:42.000 2009-10-28 20:15:10.000 Query : select DATEADD(ss,CAST(Left(min(time),10) AS...
How to setup an autobackup for the backup type of Full database and transaction log together as a single bakup file in sql2005.? We can setup to backup full database seperately and transaction log seperately, but i wanted these two should be a single backup file. Any suggestion pls. ...
10. Choosing a block size when creating VMFS datastores Eric Siebert has written a guide on how to choose the right size for VMFS datastores. 9. How to use command line arguments in VBScript via the Wscript.Arguments Object Jerry Lees explains a helpful VBScript trick. 8. Using VRDP to view...
SQL Server Management Studio only recognizes one drive on the server, how do I get it to recognize the other Local disks? The one disk it does see is also on the AX-100, but it will not list any of the others, even the interanl disk, as options for devices to create databases on or for backup...
How to export excel data to Sql server 2005 Software/Hardware used: Sql server2005 and Ms excel 2007
Hi Everyone, I need a PLSQL query inorder to keep track of TIME. Scenario : The Time Performed should be before the Other Time. Regards, Pet Software/Hardware used: OC


