• Users accessing SQL Server 2008 database

    how can i know how many users are accessing database remotely and how much load is on database .how can it be detected in sql server 2008. pls let me know .  

    Tablestructure15 pointsBadges:
  • SQL Server 2008 Management Studio evaluation edition a time bomb?

    Hi, I was just wondering if the Management Studio for SQL Server 2008 evaluation edition is also a time bomb? One of our client wants to just install the 2008 Management Studio and I was just wondering if we could use the Evaluation edition or do we have to purchase a license just to get the Client...

    Db23290 pointsBadges:
  • DBFs into SQL Server 2008

    Does anyone know of an efficient way to import DBFs into SQL Server 2008 (besides the "import into Access, then import the Access files into SQL server-method")? I don't work with SQL Server much, but I do it enough to have had this problem before (to be exact, it seems I have this problem once a...

    ITKE346,265 pointsBadges:
  • change track in sql server 2008

    HI, use Northwind Alter database [db_track] set change_tracking=on (change_retention=3 days,Auto_cleanup=on) i m running the above  command i m geting the ERROR AS Msg 5011, Level 14, State 5, Line 3 User does not have permission to alter database 'db_track', the database does not exist, or the...

    Fhhdjfhjdhfjhjdfh135 pointsBadges:
  • sql server 2008 backup and restore

    can u get me the command to recover the database . my backup is in d:nor.bak . as i m running the command   >restore database 'd:nor.bak' it gives me the message as : Incorrect syntax near 'd:nor.bak'. pls let me know how to reatore . Regards, Rino

    Fhhdjfhjdhfjhjdfh135 pointsBadges:
  • Report Server Install Best Practices

    I am setting up my first Report server. Should the Data Engine and two databases that are automatically created reside on the Report Server or on another SQL Server machine?

    Mongo7305 pointsBadges:
  • How to Make Fixed Row Table

    Hi all My question is that i want to make the table which will accept only 500 row. even it could not accept 501th row. i mean to say i can't accept at the time of insertion not on fetch time

    DotnetDevoloper30 pointsBadges:
  • SQL Server Log Shipping 2005 to 2008

    Does anyone know if i can logship from a sql server 2005 to a sql server 2008?

    Rick Martinez585 pointsBadges:
  • Partitioning in SQL Server 2005/2008

    We have partitioned 5 large tables across 10 partitions (with 10 filegroups) and with a set of 5 - 6 users the performance was adequate, with minimal conflicts (like deadlocks etc), but we want to implement this scheme that can scale to say 300 users. With regard to this I have the following...

    Inquisito20 pointsBadges:
  • Locking and concurrency in SQL server 2008

    In microsft SQL 2008 enterprise edition, readers block writers and writers block readers. What does it mean? Is it that on same set of records only one query be processed.

    Akansha150 pointsBadges:
  • Page level lock in SQL 2008

    What is the meaning of page level lock in microsoft SQL 2008 enterprise edition? How many records are locked?

    Akansha150 pointsBadges:
  • OLTP in SQL Server 2008

    While using OLTP in Micrsoft SQL 2008 enterprise edition, does the row level locking happens or table level locking happens?

    Akansha150 pointsBadges:
  • Microsoft Live Chat: Introducing Microsoft SQL Server 2008 R2 on 4/22 11am ET

    Join us on April 22nd at 11am ET to hear how SQL Server 2008 R2 can provide your IT environment with an end-to-end approach that increases efficiencies, reduced costs and an increased competitive advantage for your business. Visit the blog today to learn more and ask your questions in the...

    EmNichs3,250 pointsBadges:
  • Implement SQL Service Broker with SP

    Hi, Can some one help me by giving a sample program in detail on how to implement service broker concept using Stored procedures across different servers, and with in a DB and between Databases. It would be a great help if I could get answer at the earlest. Regards Jeevan

    SQLHELP5 pointsBadges:
  • 16 node failover clustering in SQL Server 2008

    How can 16 node failover clustering be achieved in Microsft SQL 2008 enterprise edition? Are all nodes in active state? How many nodes can remain active?

    Akansha150 pointsBadges:
  • Policy Management – SQL Server 2008

    I have installed SQL Server 2008 Developers Edition on Laptop witrh XP. All installed ok but noted that under Management section there is no policy management. Is this a separate option during the installation or not included in the Developers 2008 edition of MS SQL Studio?

    Ganners255 pointsBadges:
  • Oracle 10g versus Microsoft SQL Server 2008

    Require comparison between Microsoft SQL 2008 enterprise edition versus oracle 10g standard edition.

    Akansha150 pointsBadges:
  • SQL find duplicates SQL Server 2008

    Up against a SQL question that is difficult to code.  Any help is greatly appreciated.

    Jtigges5 pointsBadges:
  • Adding users to my SQL Server 2008

    How do I increase the number of users CAl to my SQL server 2008 Licensed by server?

    Georgy25 pointsBadges:
  • What is the easiest and best Front End development for SQL server.

    What is the easiest and best Front End development for SQL server. I have Visual Studio 2008 Professional IDE. VB.net or VB.

    KRMerker5315 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