SQL Server

Setting up dbmail in SQL Server 2005 on Server 2003

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...

TFS VSTS2010

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...

Stored procedure content

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

Refresh Reporting Services to view newly added sproc fields

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

The IT Blog Top 10: Nov. 5, 2009

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...

Effective ways for retrieving millions of records from a table?

I have two tables -- [em]Users[/em] and [em]UserAddress[/em] -- with 30 million records in each. Software/Hardware used: SQL Server

Troubleshooting Data Mining in SQL Server Analysis Services 2005

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:...

Constraints (MySql,tables,null,PK,FK etc)

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...

The most-watched IT questions this week: Nov. 3, 2009

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...

SQL Server 2005 on Windows 2008 64 bit SP2. Installation issue

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...

How to export/ import userschema in SQL server 2005?

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.      

Select - Top 10

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...

Security Update for SQL Server 2005 Service Pack 3 (KB970892)

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.

Access 2003: Can't filter Part-no's by highest $Spend Plant/Site

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...

Date Time SQL Selection Criteria

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...

Auto backup configuration in SQL2005

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. ...

The IT Blog Top 10: Oct. 29, 2009

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 2005 will not recognize other local disks

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

How to export excel data to Sql server 2005 Software/Hardware used: Sql server2005 and Ms excel 2007

About Time

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