• How to access a database on a remote SQL Server

    I want to access a database on a remote SQL Server in my organization. I need to access it with my Visual Basic (VB) application. I can do it on the local machine but not on my remote machine. How do I resolve the issue?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Configuring a SQL Server installation to accept only SQL Server authentication

    How do you configure a SQL Server installation to accept only SQL Server authentication and not both SQL and Windows authentication?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Using DTS objects for scripts to alter SQL Server password

    Is it possible to use DTS objects to create scripts to alter the SQL Server password I assigned when I installed the server?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Stored procedures in SSRS

    Can we call the stored procedure in SSRS when creating reports.I am new to sql server plaese help me in this question

    Sriradhi25 pointsBadges:
  • Looking for best way to have SQL Server data security, replication as well as security maintenance

    I joined a production environment recently, and I’m the key person here. We have 2 servers: one production server and a replication server. Data from the application goes to the production server every second and that is replicated to the replication server. We fetch the data from replication...

    SQL Server Ask the Experts2,585 pointsBadges:
  • how to upgrade server to SQL 2005

    I have a system with MS SQL Server 2005 installed and am running the MS SQL Server Management Studio Express but when I query the database version it comes back as SQL 2000 - 8.00.194. How do it change to using SQL 2005?

    Cjdechris5 pointsBadges:
  • sql scripts

    Hi all, i'm updating a new 'commun management' software n i wanna update the database bcoz i added many extra tables. i did write scripts for all the tables this way: Create........... Drop........... Alter........ so our clients would be able to have access to it. but i have been asked to write...

    JARON5 pointsBadges:
  • Restoring SQL Server 2000 database

    I want to restore a database in SQL Server 2000, using a specific name. I tried restoring it using Enterprise Manager, but kept getting the error 'You must select a backup set to restore'. Why is this and how do I resolve it?

    Gini_25 pointsBadges:
  • how to update a row in grid view in vb.net

    how to update a row in grid view in vb.net using sql server as back end

    Anupamak1515 pointsBadges:
  • Problem converting Access SQL query to T-SQL 2005

    I have a SQL Server 2005 database. One of my co-workers has put a MS Access front-end on it, because of the ease of designing queries in Access. I need to convert an existing query from Access SQL to T-SQL to put it into production. So far, I have removed all the obvious differences between the 2,...

    Chunkydrew15 pointsBadges:
  • Linking Microsoft CRM to MSSQL Server

    We are currently setting up a email newsletter system for one of our client and are looking at linking to and fro their CRM, for example, we need to link our newsletters (stored in MSSQL) to their list of contact emails (Stored in CRM) and write information related to the newsletter usage back to...

    Estellemorris15 pointsBadges:
  • Veritas vs. SQL Server 2005

    Why will SQL Server not accept files restored from Veritas backups?

    Patticake5 pointsBadges:
  • GPO — increasing logon banner size

    how to configure a logon banners that can exceed 512 characters in length in window server 2003?

    Rmcfarla0 pointsBadges:
  • 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:
  • 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 Rouse5,820 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:

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