• Email sp_who2 on lock/wait sql server 2008

    I have an alert set up to run a stored proc that will email me the results of a sp_who2 when the Lock Waits/sec rises above 2 seconds. The problem is that the alert doesn't fire off until after the lock has cleared, so the results of the sp_who2 are not very useful because they don't contain the...

    TJay85 pointsBadges:
  • Accessing email with Outlook on multiple computers

    I was wondering what the best solution is for the following situation. We are increasing the size of our network and intalling a Windows 2003 server with Active Directory. My users will have to work from multiple workstation. Is there a way I can configure the system that will allow the users to...

    Skepticals0 pointsBadges:
  • Fill out your profile and add a picture to win an iPad

    If you haven't filled out your profile and added your picture, do it now and you could win an iPad. Once you've added your picture and filled out your profile, add a comment to this post to let me know and I'll give you 100 Knowledge Points.  To increase your chances of winning, here's how to...

    EmNichs3,250 pointsBadges:
  • Restoring LTO3 tape without the app that backed it up

    Is it possible to restore data on a LTO3 tape without the application (ArcServe2000) that backed it up?

    NewnanIT1,110 pointsBadges:
  • Win Drupal’s Building Blocks!

    Are you a developer? Today's free IT book is an essential addition to your library: Drupal's Building Blocks. Learn how to quickly build web sites with CCK, Views, and Panels after you win this great resource. There are two ways to win this book: Answer one of five questions and post the link to...

    MelanieYarbrough6,345 pointsBadges:
  • EXEC and sp_executesql

    Could someone give me a concise summary of the differences between EXEC and sp_executesql? Should we set standards that require the use of one over the other by our developers? Cheers

    Douglasnz0 pointsBadges:
  • SQL 2005 Database instance

    Hi there i have a windows 2003 domain in our school, i have a problem with my sql 2005 database. im trying to uninstall a instance from the database engine. it wont uninstall. i believe that this is corrupt. im trying to reinstall sophos but as the old database will not uninstall sophos wont...

    Philcrox160 pointsBadges:
  • SQL Server Fails to Start When Moved to Different Node

    Sql 2008 R2 on Windows 2008 R2 cluster. When I move instance from node 1 to node 2 everything is fine: all resources come online as they should. When I move the instance from node 2 to node 1, all resources except sql server and agent come online. If I delete errorlog and start the sql server...

    Spadasoe5,130 pointsBadges:
  • alter database

    HI, when i run the command alter database northwind set multi_user with rollback immediate the northwind database shows ACCESS denied and tagged as SINGLE USER i donot understand why it so .can u pls explain .

    Fhhdjfhjdhfjhjdfh135 pointsBadges:
  • how I can connect my local SQL server2008 with another one via internet?

    how I can connect my local SQL server2008 with another one via internet?

    Netkrom10 pointsBadges:
  • MSQL Auditing

    Hello. I'm dot.net developer, and i'm working a lot with MSQL. My current task is when some user executes select query on database, i should "catch" the query data. What do i mean is if select query is "select * from UsersTbl where UserID = 5", i have to get  '5'. Does somebody have any idea...

    Dimon745 pointsBadges:
  • I want to create backup of SQL database and set a password.

    HEllo All  i want to create backup of SQL database and want to set Password that anyone who restore this backup after that it cant be able to restore database without knowing perticular Password .... is this Possible....? if Yes please tell me How...? Thanking You Raviraj

    Raviraj1235 pointsBadges:
  • Subfile sort

    I have a subfile program for updating, creating, and displaying item information the user can select from to create, view or update detail. The subfile shows item number, description, etc from my main file (i'll call itemnum1)and a vendor item number from an auxiliary file (itemnum2). My question...

    filuphaze475 pointsBadges:
  • How to install SQL 2005

    Hey what was minimum hardware requried for SQL2005

    Roony5 pointsBadges:
  • Slow response with SQL server over a network.

    Hi, We do a simple select 1 million record over a client server setup with SQL server 2008 and it take 10 times more time to get the results that doing the same request with Microsoft access db. Exactly the same setup for the network. Any special setup in SQL server we are missing. thank you for...

    Jack26015 pointsBadges:
  • Stored procedures to script table data in SQL Server 2005

    Are there any stored procedures or command line utilities that I can use to script out the data from a particular table in SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Recovering lost data from SQL Server 2005

    Running SQL Server 2005. I found that I had lost about 2000 records the Assets table and more records in the associated tables Timeassets and AssetBillingrates.  Each of the tables uses an Id field as the Primary Key. I was able to identify the key records that had been lost and tried inserting...

    BClawson10 pointsBadges:
  • How to move sql server clustered instance to a separate stand alone server

    We are in the process of moving our Production instance and databases. Would be of nice help if anyone could shed their thoughts on How to move sql server clustered instance to a seperate stand alone server (along with system and user databases). We are stopping the cluster, moving the drives to a...

    Sqlserver2008r25 pointsBadges:
  • Crystal database expert not showing views for database

    When I open database expert and open a new DB connection, only tables and stored procedures are shown. How do I get views to show? I can see views for other databases except this one.

    denise7525 pointsBadges:
  • How to handle record lock using embedded SQL?

    I am using SQLRPGLE program,need to handle record lock in sql statement ..plz suggest?

    Samule400160 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