• Database Creation

    Recieving an error for database creation permission for sql 2005. Please advise

    Praya5 pointsBadges:
  • Install SQL Server 2005 without Local Admin

    Books Online tells me ... make sure you have administrator permissions on the computer where SQL Server will be installed. Based on the principle of using the lowest possible user rights is it possible to safely install SQL Server 2005 using an account or group that has the required level of...

    barronadmin0 pointsBadges:
  • how can i retrieve the data from sql-server2005 from multiple tables in two combo-boxes in vb6.0 using programming code

    how can i retrieve the data from sql-server 2005 from multiple tables in two combo-boxes in vb6.0 using programming code

    Narendar30 pointsBadges:
  • Setting up database mirroring for disaster recovery in SQL Server

    I am a SQL Server DBA and in the process of upgrading our SQL Server 2000 to SQL Server 2005. I’ll be using database mirroring for the disaster recovery in SQL Server. One question I have is once I failover to the mirror server and use it as a principal for a couple of days, how do I make sure...

    SQL Server Ask the Experts2,585 pointsBadges:
  • synonym in SQL server 2005

    How can one get the information about the object type of synonym that is whether the synonym belongs to function, stored procedure, table or view using a query. Sys.synonyms table contains information about synonyms present in a particular database but it does not tell for which object the synonym...

    Bhavnarang855 pointsBadges:
  • Access rights for all user of an SQL SERVER 2005

    Hi all, have you an idea how can i export the list of users and there access rights of an SQL SERVER 2005; THANK YOU

    Backtrack85 pointsBadges:
  • as400 db2 to sql server 2005

    how can we take a db2 backup tape and dump to a sql server 2005 database?

    Mingo5 pointsBadges:
  • Upgrade SQL Server 2005 32-bit to SQL Server 2005 64 bit

    Hi, We have one development server which is running on sql 2005 32 bit contains Databases ( including Tables, SPs, views, assemblies..etc) Applications ( .net 2.0 web application, crystal reports..etc) Note: now this databases & application is under development stage. But our plan is in future we...

    Jadi5 pointsBadges:
  • Finding the total size of databases on SQL Server 2000 and SQL Server 2005

    Is there a quick way to find the total size of each database on SQL Server 2000 and SQL Server 2005? I have tried running “sp_spaceused”, but I do not want to run it manually for each database. Do you have any ideas?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Restoring a SQL Server 2005 database from a public share backup

    Is it true that even in SQL Server 2005 you cannot restore a database from a backup on a public share, but ONLY from a local storage (DASD)drive?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL SERVER 2005-MAX FUNCTION

    I have a stored proc1 which returns a list of dates for one particular job number.I execute this proc in an other proc2 ,to get the list of all dates. Then in my proc2 we can get the MAX of this list of dates. In the WHERE clause of my SELECT statement, i need to filter the result set by dates less...

    Beginner in IT5 pointsBadges:
  • Access rights in SQL Server 2005 users

    Hello, I'm using Ms SQL Server 2005. I'm connecting server via ADO. I have a question about access rights. Let me tell this with an example. Let's say I have a database named as DB. In DB there are 3 tables. TBL_1, TBL_2, TBL_3. I want to create a SQL user which will have all righst on TBL_1 and...

    DetayMan5 pointsBadges:
  • Issues rebuilding system database on SQL Server Express 2005

    I am having some trouble rebuilding the system databases on my SQL Server Express 2005 instance. While I have had a total system failure, the backups have been good. I have restored the operating system but obviously there are no SQL system databases present (they were open at the time of the...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Read Excel from Sql Server 2005/2008 SQLEXPRESS

    How to read the excel data's from Sql Server 2005/2008 SQLEXPRESS

    Sridhar12350 pointsBadges:
  • shredding xml in sql server 2005

    In SQL Server 2005 one shreds XML via the nodes() method. When inserting into a table using this it preforms extremely slowly. If the "into #x" is removed the shredding is very fast. declare @x xml -- there are 1000 rows in the xml document set @xml = ' <rows> <row>...

    Skidancer5 pointsBadges:
  • convert a query from access to sql server 2005

    Ive recently been given the task of converting an application from an Access database to sql server 2005. One of the queries has this on the ORDER BY Clause ORDER BY not isdate(Obsolete), not isdate(not_relevant), isdate(assessed), isdate(published), isdate(implemented), not locally_adapted,...

    Mark...w10 pointsBadges:
  • Failed ODBC USER DSN connection to SQL Server 2005

    I developed a project in VB.net with SQL Server as the backend using ODBC Data source. I converted the DB to SQL Server 2005 and tried to change the ODBC Data source connection with a SQL Server native client. The ODBC USER DSN connection is not obtaining the SQL Server 2005 database I created. How...

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to match CSV field values in SQL Server 2005

    i have an table in sql-server 2005, in which my one field is storing csv values.Suppose i have two tables; one is roles and another is users; and multiple role can be assign to one user. so that i have make a fields i.e roles in user table which is keeping the values in csv format. now my problem...

    Sanjeevgoyal5 pointsBadges:
  • SQL Server 2005 Query Very Slow in the first run

    Hi, I have an sql query which takes 8 seconds in the first run. The next run there after takes 0.5 seconds and all consecutive runs take 0.5 seconds. Is the plan getting cached? How do i make this query run in 0.5 second in the first run itself? Please find the query below. select...

    Jsql155 pointsBadges:
  • Sorting hierachy data alphabetically in SQL Server 2005

    I have a follow-up question to the article Navigate hierarchies using recursive common table expressions. I have an employee hierarchy that follows a similar pattern to the article, but I need to be able to sort my data alphabetically within each level. Do you have any advice on how to accomplish...

    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