• Does SQL Server 2008 R2 Express have Intellisense?

    Is Intellisense available in SQL Server 2008 R2 Express Management Studio? It seems like it should be there. Is it inactive or am I doing something foolish?

    ITKE344,900 pointsBadges:
  • Logging and finding queries in SQL Server 2008

    In SQL Server 2008's activity monitor, I can see the most expensive queries. But my question is if I can actually log this info via Query Analyser? Thanks!

    ITKE344,900 pointsBadges:
  • Connecting a SQL Server database with Visual Basic 6.0

    What code would I need to connect a SQL Server database with Visual Basic 6?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Returning string value from a stored procedure in sql server 2005 to vc# ide code at runtime

    Hi, This is Pushan Chakraborty from Kolkata. I have complied 2 stored procedures to retrieve the names of 2 user defined tables that I have created. The stored procedures are set: ANSI_NULLS ON set QUOTED_IDENTIFIER ON go -- ============================================= -- Author: -- Create date:...

    Pushan12345 pointsBadges:
  • How to use SQL Server 2005

    I have installed SQL Server 2005 but I want to know how to open SQL Server and connect the DB.

    Anand79865 pointsBadges:
  • Connecting a SQL Server database with Visual C++ and .NET

    How can I connect a SQL Server database with Visual C++ and .NET?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to schedule SQL query to run in Microsoft SQL Server

    I have a query that I want to automatically schedule to run daily. How do I do this?

    House5 pointsBadges:
  • Synchronizing three SQL Servers and their data

    I have three SQL Servers: Development, Staging and Production. I need all structure and data from Production to carry over to Staging and Development, so people don’t need to enter data in three different places. I also would like it so that when data is changed in Development, it also changes...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Encypting a customer table in SQL Server 2012

    I have a customer table with contains several columns (names, address and contact info). Now, there are over 15000 records so I'm trying to figure out if I should encrypt the entire table of just several specific columns. How can I do this on a production database? Thanks!

    ITKE344,900 pointsBadges:
  • Network Security Auditing tools

    Hi all - I'm hoping somebody out there might have a suggestion for me. My company unfortunately falls under Sarbanes Oxley and we need to audit all of the network directory security. The down side of this (ok well it's all down) is that we are a small company, no money to spend on getting the...

    Lirria0 pointsBadges:
  • Windows 2003 Server configuration

    I have been asked to configure a new server for a small Health care clinic. Previously they were using a Dell Dimension as a file server with open shares throughout the network and all users logging in as administrators. Considering the risks involved with HIPAA (Health Insurance Portability and...

    Stuntz0 pointsBadges:
  • Is their a RDBMS for the Macintosh Operating System

    Is their a RDBMS for the Macintosh Operating System. I am looking for something similar to Microsoft SQL Server for Mac. Ideally something that would interface with Microsoft Office for Mac.

    BarryCC5 pointsBadges:
  • Setting up access rights in a SQL Server 2005 database

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

    SQL Server Ask the Experts2,585 pointsBadges:
  • iDB2 connection String permenant solution

    I have a DB2 connection string to our i-Series that works. "DataSource=10.10.10.10;userid=LIVEXML;password=LIVE1;DefaultCollection=DATALIB031;" We have been developing a lot of apps and web services that use this type of connection. My problem is when our i-Series software is upgraded (about every...

    ToddN20009,700 pointsBadges:
  • SQL Server configuration

    How would I configure SQL Server 2008 R2 to handle 1 million connections?

    ETCGMan40 pointsBadges:
  • Improving the initial speed of a SQL query

    I have optimized my SQL query to the maximum extent. The first time I ran the query, it took 7 seconds; the next time it took half a second. Why did this happen? How can I make the query run faster the first time around?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to Encrypt a Column in sql server 2000/2005

    How to Encrypt a Column in SQL Server 2000/2005 i.e I need something like this: @OriginalValue = 'Original Value' @EncryptedValue @Key int set @Key = '123#$2hj$dfgh*67kjugd45j45s4agd' --any unique key value for encrypting and decrypting set @EncryptedValue = fn_Encrypt(@OriginalValue, @Key) insert...

    Dot net lerner5 pointsBadges:
  • Encrypt a Column in SQL Server 2005

    I'm trying to encrypt a column. Unfortunately I don't have access to the C# source code that is accessing the data. All the instructions I've found require me to use the decrypt function in my SQL command. How do I automatically encrypt and decrypt without being able to change the source code? Is...

    Jfw10075 pointsBadges:
  • Ability to spawn (or fork) a sproc in SQL Server 2000

    Is it possible in SQL Server 2000 for a sproc to call another sproc and then return it's output variables and close before (or while) the nested sproc processes? Goal is to nest a sproc that willl perform auditing on the called sproc without slowing it down waiting for the auditing.

    CO Bill120 pointsBadges:
  • How to restore Sql Server 2000 mdf and ldf data

    I have MDF and LDF files with different modified dates. How could I attach these to SQL Server 2000

    Databaseserver20 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