• The most-watched IT questions this week: Dec. 8, 2009

    Here are the 10 most watched questions on ITKE: There’s some great discussion going on. Go answer a question now! 1. Pushan1234 asks about Returning string value from a stored procedure in sql server 2005 to vc# ide code at runtime. CarlosDL and MrDenny provide some pointers. 2. Bonbon78 runs...

    ITKE351,865 pointsBadges:
  • SQL Server 2008 & Team Foundation 2008

    Hi All, Just wondering if anyone has had issue with using SQL Server 2008 with Team Foundation Server 2008. I know there was a compatibility error that occurred when you tried to installing TFS with SQL Server 2008 however this was address with TFS SP1, are there any issue or error that I should...

    Db23290 pointsBadges:
  • (rsErrorOpeningConnection) Could not obtain information about Windows NT

    I am trying to deploy a report to the Reporting Services Server 2008 but keep running up against this error:

    Amcintryre5 pointsBadges:
  • How can I affect the user profile previous sign-on date with out sign on interactive.

    We have a windows system for invoices from our suppliers. To exchanges files the system map to a folders in I-series IFS-system. We have a special user profile for the system to use. The system map to I-serie and every thing is ok all the servers stays up day and night. The problem is after 60 days...

    TBJSweden0 pointsBadges:
  • SQL DTS package scheduling

    When a DTS package is scheduled to run at a specific time of day, is it done through the use of a stored procedure or a job?

    Gic5 pointsBadges:
  • Reconnecting to databases in SharePoint after server wipe

    My Windows Server 2003 box died which had WSS 3.0 on it. The server has been wiped and I still have the SQL Server intact. Everything is reinstalling now; can I just reinstall SharePoint and "reconnect" to the databases that already are there or do I need to start all over?

    ITKE351,865 pointsBadges:
  • SQL Server 2005 Performance optimiztion

    I have the following setup, would like to know what's best for log files, data files, indexes, tempdb files. Also, since the server is used solely for SQL 2005 Reporting Services, how many tempdb data files and tempdb log files should I create, also how many userdb data files and userdb log files....

    ITKE351,865 pointsBadges:
  • SQl Server 2008 Plain Text procedures results iin Encrypted Text within Profiler

    I am attempting to trace some SQL activity on a SQL 2008, Standard SP1 64-bit server. In the profiler trace, I keep seeing Encrypted Text in the textdata column for triggers and procedures that are clearly plain text and are not encrypted. In this example, the object is a trigger. I do notice that...

    ITKE351,865 pointsBadges:
  • The most-watched IT questions this week: Nov. 24, 2009

    Here are the 10 most watched questions on ITKE: There’s some great discussion going on. Go answer a question now! 1. Cluster drives moving windows server 2003 r2 32 bit was asked by a reader and answered by Mrdenny. 2. Migrating to virtualized environment purely to retain support for legacy...

    Michael Morisy8,323 pointsBadges:
  • SQL Server 2005 Error Registering database

    I try to copy SQL Server 2005 Database to VISUAL Jobshop (ERP INFOR) get message when VJS DB Wizard of Jobshop tries to create catalogue tables "Error registering database - operation is not allowed when object is closed" Thanks for help where I have to look to solve that problem.

    ITKE351,865 pointsBadges:
  • 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...

    ITKE351,865 pointsBadges:
  • Crystal Reports problem

    here's the coding for my crystal report display The above code is written in the report viewer form's load event method. 'this is the query for my dataset (used in objItemSale.GetSaleData(string) function) SELECT ItemSale.BillNo, ItemSale.IncomeID, Income.IncomeDate, Income.IncomeValue,...

    Obhasha0795 pointsBadges:
  • How do I confirm all the data moved from Source to target for different tables

    How do I confirm all the data moved from Source to target for different tables. I am not able to phrase this question. Bottom line I want to make sure all the data was transferred to target database. That is my test to validate. Thanks

    Gvsatyam5 pointsBadges:
  • hardware requirement for sql 2005.

    Hi all, We are planning into SQL 2005 server (windows server 2003)with multipledatabases of sizes of around 10gb.What should be the CPU speeds ,type of CPU and RAM requirements for ir

    Infrastucture25 pointsBadges:
  • Nominate a member for our latest Panasonic flatscreen giveaway

    In our latest (and biggest!) IT Knowledge Exchange giveaway, we're giving thanks to the star members of the community who provide quality contributions in their questions, answers and discussions. Did a member answer your question in a particularly great way?Did someone recently contribute to a...

    ITKE351,865 pointsBadges:
  • sql help

    is there a way to update multiple records in a table the meet criteria from another table. here is what i'm trying update table/detail set condition = 'r' where condition = ' ' and number_d = (select number_h from table/header where date between 050101 and 051231) thanks in advance

    Cowboypgmr0 pointsBadges:
  • Rename Sheet when report exported to excel

    hi, When i export SSRS report to excel, each new page comes with new sheet. The sheet names are default names (sheet1, sheet2.. sheetn). Is there a way to rename these sheet names while exporting. Thanks in Advance, Rachitha.

    Rachi5 pointsBadges:
  • Dell Optiplex GX520 hibernation/sleep mode issues

    Hello, We have several Dell Optiplex GX520's on the network running Windows XP pro. They randomly fall into sleep mode. Moving the mouse will not wake them - you have to push the power button to get them out of sleep mode. Also we are not able to remotely wake them to do patch updates or remotely...

    Jmello0 pointsBadges:
  • SA Password change for SQL

     What is the easiest procedure for changing the SA password, and what is the procedure for testing the password change?

    Syscheck5 pointsBadges:
  • What is correct syntax for SQL for Maxrecords in OS400/DB2?

    What is correct syntax for SQL for Maxrecords in OS400/DB2? We have a process automatically generating SQL code. However, our iSeries doesn't recognise the code it generates for maxrecords. Here are the examples of what I mean. The DB2 database seems happy with SELECT I1PHON,I1ACC,I1ACC1, FROM...

    Peterax0 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following