• Journey from SQL/400 to SQL Server Development

    I'm fairly comptent with SQL/400 , scripting, etc. - - how difficult would it be to applying this to learning something like "SQL Server" ?

    Tsmith7155315 pointsBadges:
  • NIC info via script!!!

    Hiya all, I have made a script (Copy and paste from microsoft, then tweak!!!!) to give me certain PC specs, and want to know how to add the NIC information to it, the script gvies me PC name, manufacturer, CPU make, model, speed, RAM, VGA adapter, and i just wanna add the NIC to it. If i can do...

    Carl0s810 pointsBadges:
  • How do I integrate SQL Server Integration Services and Blaze Advisor?

    I am a Microsoft Business Intelligence (BI) Developer and currently working on a Pharmaceutical BI project. The client wants to integrate his Blaze Advisor rule engine to SQL Server Integration Services (SSIS) so that he can change the rules in Blaze Advisor any time and see the effect of it on the...

    SQL Server Ask the Experts2,585 pointsBadges:
  • COUNT(*) Statement is slow with 3+ million records

    Hi, I have a table with 30 columns, a indexed unique field and 3+ million records. When I try a simple SELECT COUNT(*) statement its take 5-7 sec. to give the output. And I am showing this output to my front end application ASP.Net taking 1 min to show the count in front end. I am doing some other...

    Bab Ganesh15 pointsBadges:
  • SQL 2000 to Yukon Migration

    Posted on behalf of Kilaru: We have 4-5 applications on the front end of a portal. On the backend we have mapped these applications to SQL server 2000 Databases. Now, we are planning to migrate on the backend databases to Yukon and map it to the application on the front end. My question: Is it...

    Margaret Rouse1,915 pointsBadges:
  • sql server 2000

    i am learnin sql server 2000 by ownself tell me the wright way how i can learn after this i shall go for oracle

    Agnihotri0 pointsBadges:
  • Why might a maintenance plan fail to generate a SQL Server job?

    I was reading the article “Use the database maintenance plan wizard” on SearchSQLServer.com and wanted to ask, why in some cases, a maintenance plan would fail to generate a SQL Server job. I currently have cases where a maintenance plan was saved but jobs were not created at all or, in one...

    SQL Server Ask the Experts2,585 pointsBadges:
  • run DBCC SQLPREF on linked server.

    I want to run DBCC command on linked server remotly

    Mangesh jadhav5 pointsBadges:
  • IT Career Path

    I am a new graduate with 1 year of experince in a well known Aircraft Manufacturing company. My title is "Database Administrator - Operations" and I deal mainly with SQL Server back ends with Visual Basic or HTML front ends. I currently deal with many internal customers and relay the feedback to...

    D-Nel5 pointsBadges:
  • Reporting Services – Deploy error

    Hi there, I recently changed my computer name, and from that moment the SQL Server Development Studio couldn't deploy my project anymore. It successfully builds the project, but can't deploy it. It returns the following error message: "A connection could not be made to the report server...

    Barend IT15 pointsBadges:
  • Need to format to hh:mm:ss

    I'm creating a report in SSRS 2000 and one field reflects time spend on phone daily. However is being displayed as for example, OutboundHours 4818. How can I get this to display in the report as hh:mm:ss. Is there code that I can plug into a variable or syntax that will accomplish this? I don't...

    Latingntlman5 pointsBadges:
  • Looking for commercial software that does data driven subscriptions for SQL Server Reporting Services

    Is there any commercially available supported software that does data driven subscriptions for Reporting Services? This is the *only* feature we need from the enterprise edition and we are looking for alternatives to paying MS $30,000 just to get this one capability.

    SQL Server Ask the Experts2,585 pointsBadges:
  • Execution time is varying with query analyzer and visual studio 2005

    when a stored procedure is executed in query analyzer its working fine and getting the result quickly.but when same procedure is executed through visual studio timeout expired error is generated.can any one olve this issue

    Abcp5 pointsBadges:
  • Retrieve data (ETL) from 32 bit architecture to a data warehouse running 64 bit

    The proposed data warehouse platform will be a 64 bit platform - both OS and SQL2K5. Will there be any issues with drivers or anything else you can think of as I'll be pulling data (ETL processes will reside on the 64 bit platform) from multiple databases on 32 bit OS and SQL2K5 platforms?

    Jmc5 pointsBadges:
  • Sql server 2005 database filesize auto grow

    Hi i'm running sql server 2005 sp2 on a w2k cluster; i'm expericing this issue whereby the file size of a particular database will auto increase even though no one is even accessing it. Is there anyway to findout the cause of this issue or how can i stop the database from auto increasing the file...

    fartman50 pointsBadges:
  • OPEN .DTS WITH WRONG APPLICATION

    JUST OPEN .DTS FILE OF THE SQL SERVER 2000 WITH NOTEPAD APPLICATION, AND THE .DTS LOGO HAS BEEN CHANGED TO NTOEPAD LOGO, IS IT POSSIBLE TO CHANGE BACK TO .DTS LOGO? THANKS.

    Just5 pointsBadges:
  • Random number generation

    Hi, I have a 6 digit number. I need to make this as a 10 characters with those 6 digits within it. For eg, if my input number is 123456, the result should be a4y2d365p1. some combination of characters with the original 6 digit numbers. Please do let me know if this could be done by any ways..

    Coolgirl045 pointsBadges:
  • Read Only access to a SQL Database? Best way?

    We're trying to prevent hacks on our site. We've been down several times and the idea came up that we could prevent the SQL Injections by making an account for just the public-facing side of the site that has Read Only set for it. This is a Microsoft SQL 2000 server BTW. Our hosting company...

    Kwoodall10 pointsBadges:
  • Oracle 10g on Windows 2003 virtual server

    We have installed a SQL server on Windows 2003 virtual server and there were performance issues. Will oracle 10g make a significant difference in terms of performance? Are there known issues concerning 10g DB running on Microsoft 2003 virtual server? thanks

    Markv5 pointsBadges:
  • Utility to Compare Security Configuration Between Database

    We are trying to restore a SQL Server 2005 database from a production to a QA environment. We are using certificate security, multiple schemas and certificate signed stored procedures. We need to find a utility which can tell us security configuration differences between the two environments. Any...

    Aiguy5 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