• Problem occuring while performing Mirroring

    Hi, I underwent the following Steps for creating a mirror in sql server 2005. 1. Downloaded and isntalled sp2 in principal,mirror as well as witness servers 2. Created a new database named it as FinalMirror 3. Right clicked on the database Tasks-backup-BackupType--Full--Ok created FinalMirror.bak...

    Cmrhema5 pointsBadges:
  • New user permission to SQL server

    Hi all, I have created a new local user on the sql server. Now when i access the sql enterprise server, it fails and gives error as " login failed to user, check SQL registration properties. Thank you.

    Mutallib5 pointsBadges:
  • SQL Server 2005 – Are There Any Easy Appl. Builders

    Hi, Is there a easy application builder for a PC to access a SQL Server 2005 Database that will give it the ability to do Inserts, Update, and Deletes? Is there a program that can read in a SQL Server 2005 Schema and generate forms to do updates and reporting? Are there any Open Source Apps or low...

    Tsmith235 pointsBadges:
  • Replication

    Can I have multiple Distributors configured on one SQL Server instance? Also, can I have multiple Distributors configured on one SQL Server instance? Finally, can I have multiple Subscribers configured on one SQL Server instance?

    Consultant16535 pointsBadges:
  • How to pass Parameter of stored procedure Crystal report

    How to pass parameter of Crystal report from visual Basic while crystal report created with stored procedure

    N75 pointsBadges:
  • fore front – Can FCS be installed on sql express 2005

    Can FCS be installed on sql express 2005, and if yes what is the requirements as per the web site it can be done but how !!!!??? eveywhere else they are saying its not supported http://www.microsoft.com/forefront/serversecurity/mgmt/sysreqs.mspx

    Rami220 pointsBadges:
  • about checkbox

    Iam just at the very basic level of entering a boolean value(yes/no) for the check box cheked value in to a database with field check...for this Iam using a string variable checkvalue and proceeding like this private sub submitbtn_click(.......) dim checkvalue as string="" if checkbox1.checked=...

    Anupamak1515 pointsBadges:
  • Looking to resolve SQL Server performance problems caused by using many temporary tables

    I need your advice on the SQL Server performance tuning. The Problem: We use a lot of temporary tables in our application, which is causing a lot of SQL Server performance problems. I read about the following solution on some site. "RamDisk presents a powerful solution to this problem by providing...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Microsoft SQL 2005 Networking

    Hi I'm a software developer and i use Visual C# 2005 and Microsoft SQL 2005 to create my desktop applications my application is a software will be installed in to client machines as 2 home PC and i want to make the two software's connect throw Ethernet to my database which it located on one of the...

    M200015 pointsBadges:
  • How to back up SQL Server database file on a different shared network

    I want to back up a SQL Server database file on a different system shared folder which is in different WAN network. How can I do this and are there any other backup methods available in SQL Server?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Potential over & under security issues with SQLNative Client ?

    Hello, I've been unable to find any reports of these two problem when using the SQL Native Client driver (9.00.3042.00), so I'm hoping else has seen these. Firstly check constraint definitions accessed by the following TSQL only returns data with the SQL Server driver, ie nothing with SQL Native...

    WarwickW5 pointsBadges:
  • Activesync And Server 2000

    I'm having trouble with setting up my AT&T Tilt with Server 2000. I have Activesync 4.5 and it will not conect to the server. I've been told there is no upgrade for Server 2000 but there has to be a way short of upgrading to 2003. I just need to get my Email from the Exchange. Please help.

    Mountian Bubba5 pointsBadges:
  • Which is more advanced in an Excel/Microsoft SQL Server Analysis Services environment, MDX or UDM?

    Which is more advanced in an Excel/Microsoft SQL Server Analysis Services environment, MDX or UDM?

    SQL Server Ask the Experts2,585 pointsBadges:
  • What are the best practices for storing SQL Server application/program files on a SAN?

    We have a non-clustered SQL Server with a Storage Area Network (SAN) on it. What are industry standards/best practices for the location of the application/program files? Is it okay to put the app files on the SAN? We usually put them on local disk storage, but due to an incorrect installation, they...

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to create an SSIS package for importing an Access table to SQL Server, running SPs and exporting data to Excel

    I need to create a SQL Server Integration Services (SSIS) package for importing an MS Access table into SQL Server, then running some stored procedures on this database and finally exporting the result to Excel. I am comfortable in writing queries and working in Management Studio but I don’t know...

    SQL Server Ask the Experts2,585 pointsBadges:
  • When designing a data warehouse in SQL Server what is the best setting for the varchar data type?

    I am designing a data warehouse database to be implemented in SQL Server. There are a number of variable length character fields for which I intend to use the varchar field type. On previous data warehouse implementations in Oracle, I frequently set the length for the varchar fields higher than the...

    SQL Server Ask the Experts2,585 pointsBadges:
  • How can I collect database/server information across multiple MSSQL versions.

    I would like to collect database info(backups, databases, logins, etc) as well as server information ( MSSQL version, patch level, etc). I would like to use one server to collect information from all of my servers. I have MSSQL 7, 2000, & 2005 on Windows servers 2000 & 2003. I am also new to MSSQL...

    AngieJo20 pointsBadges:
  • Great Plains 8 ODBC Error (45)

    This just started today, Great Plains has been working for a good time now. I get first error message when logging on " A get/change first operation on table 'tablename' (45)." And then when you click on More Info... it says "[Microsoft][ODBC SQL Server Driver][SQL Server]Database'Databasename' is...

    bradob160 pointsBadges:
  • Are there any issues with setting up SQL Server 2005 log shipping with TDP & TSM?

    Are there any issues with setting up SQL Server 2005 log shipping with TDP & TSM?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server beginner looking for advice on performance tuning and maintenance

    I am particularly new to database management. I would like to know what I should monitor everyday on SQL Server. We have 40 databases – all the users complain to me that it is very slow. The hardware part is OK. Please tell me how I can tune & maintain databases. Where should I start? It is a...

    SQL Server Ask the Experts2,585 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