• 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:
  • Create a dialog between SQL Server Service Broker and Oracle Streams Advanced Queuing?

    Is there a way to create a dialog between SQL Server Service Broker and Oracle Streams Advanced Queuing?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Design a SQL Server trigger to calculate column averages and return them to another table

    I'm quite new to SQL Server and I’m struggling to design a trigger. I need this trigger to execute daily and calculate averages of columns and return them to another table.

    SQL Server Ask the Experts2,585 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:
  • Retrieving and storing an image in SQL Server

    How can I retrieve and store an image in SQL Server using Visual Basic 2008?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Creating stored procedures to execute tables at runtime on a SQL Server

    I’d like to execute different tables at runtime on my SQL Server by creating stored procedures. This is the syntax I am attempting to use: create procedure sp1(colname varchar(400), tab_name IN varchar2) AS BEGIN select * from '@TABLENAME' where CompanyName='@COLUMNNAME' end Is this syntax...

    SQL Server Ask the Experts2,585 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:
  • Virtualizing a SQL Server cluster in a production environment

    What is Microsoft's official position in using virtualization (Virtual servers such as VMWare, etc.) for a SQL Server cluster (two node Active Passive) in a production environment? What are the best practices?

    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:
  • SQL Server restore job fails

    I've created a Restore Job under SQL Server Agent. Job owner is sa, Run as User dbo. There are no users connected to the database or processes running. The job fails with: Msg 3101, Sev 16: Exclusive access could not be obtained because the database is in use. [SQLSTATE 42000] Msg 3013, Sev...

    TuftsDBA0 pointsBadges:
  • Upgrading from SQL Server 2000 SP3 to SQL Server 2000 SP4

    We have SQL Server 2000 SP3 running on Windows 2003 Server. Every week, after running our optimization and integrity checks on Sunday, we get this error: Time out occurred while waiting for buffer latch type 2... This happens several hours into the day every Monday. Would upgrading to SQL Server...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Mainframe access to SQL server data

    How can I access SQL server data from a mainframe COBOL program?

    Artisan5 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