• 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:
  • Help needed for date dimension which is not rolled up properly.

    I'm new to SSAS and I have dim_date table. Which have DateKey which is int and primary key (Eg data 19010101, 19010102 etc.,), date which is datetime(eg: 1901-01-02 00:00:00Z), year - smallint(Eg: 1901), month -tinyint(Eg: 01), monthname -varchar(January), day -tinyint (Eg: 1), dayname - Varchar...

    Sree11195 pointsBadges:
  • Need to upgrade sql server

    Hi right now my database server running on sql server 2000 & my application is also running from the same server for heavy load on server i m going to seperate my database server & application server i need a help bocz my database size is all most 3 GB. also i need to upgrade my database on new...

    Ravijoshi2020 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:
  • sql instance

    what is a sql server instance for? thanks.

    CarlosH5 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:
  • Planning to move data on new databse server?

    Well i m working in MNC As a Network admin actually we have one server having data & application so both our application and database on same server & now we are facing some problem on it so we plan to seperate database server & application if any body has a plan or he/she know how move our...

    Ravijoshi2020 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:
  • iSeries DB2 SQL subquery to compare yesterday sales to 120 day ternd

    Hi, I have an SQL query that I would like to populate with veriable date information each time it runs. If I hard code the dates, I get the results I expect. However, I can not get the date parameters to work with my query. Here's the " Hard coded version (Works) SELECT...

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

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