• how to update a remote sql server2005 database on webserver with multiple similar local database on windows server 2003

    Hello, I am developing an application which has several local windows server 2003. All the servers are having sql server 2005 database exactly similar structure but different datas. I want to keep a remote webserver server having a similar database updated online from all these local servers over...

    Sahaj5 pointsBadges:
  • MS Office defaults when instlling via Group Policy

    I recently created a packaged install of Office 2003 to assign to workstations. I created a .mst file with my specifications and deployed the package. Everything worked great except when I launch Word for the first time the computer prompts me for my Name and Initils. Is there a way to configure...

    Skepticals0 pointsBadges:
  • 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:
  • Database Newbie

    Im quite new to database security and MSSQL server 2005 and 2008 and was hoping to find some extra sites or books to help as I am currently writing an application to send OS info and service tags to our SQL server. I obviously can t have the SQL server directly on the internet with an open port but...

    Neutrino30 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:
  • Encryption Form SQL Server 2000

    I want to transfer data from one database to another database both the databases are on sqlserver 2000 i want to transfer the data in encrytion form how do i do it ..... Regards, Sahil

    Maruf245 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,775 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:

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