• 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!

    ITKE352,565 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:
  • 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...

    ToddN200015,605 pointsBadges:
  • SQL Server configuration

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

    ETCGMan40 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:
  • Call a iSeries stored proc from a SQL server 2005 stored proc

    Ok I'm missing something. I've tried entering a few examples I have found in forums but can't get past a syntax error I cannot find. I'm using a linked server as well. Here is the code for the SP. Any pointers would be great! USE [MyDB] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER...

    ToddN200015,605 pointsBadges:
  • Accessing another database using a variable

    I have a select like this: SELECT a.part_id, a.descript, b.location from PART_MASTER a, anotherdatabase.INVENTORY b where a.part_id = b.part_id Is it possible to use a @variable to identify the other database, rather than hard coding it? (I've tried @db2.INVENTORY b) but SQL SERVER 2000 doesn't...

    CO Bill120 pointsBadges:
  • Free IT Book: Official Cert Guide for CCNP Security SECURE 642-637

    This week's free IT book is just what you need if you're planning to take your CCNP Security SECURE 642-637 certification exam. From exam topics and quizzes to exam prep tasks and realistic exam questions, the Official Cert Guide is a must for everyone preparing or planning to prepare for this...

    MelanieYarbrough6,345 pointsBadges:
  • How to read data from a stored procedure in RPGLE

    How do I read data from a stored procedure?

    CitizenJoe15 pointsBadges:
  • How to retrieve, add and update data manually using VB.NET 2005

    Hey guys! I'm quite new to VB.NET 2005. I need to know how to add, update and retrieve data manually using VB.NET 2005. In the software which I'm trying to implement, data is entered in text boxes and then they are updated/added into an SQL table. When retrieving the data, for example: A student is...

    Obhasha0795 pointsBadges:
  • Free IT Book: Fedora and Red Hat Enterprise Linux

    The Practical Guide to Fedora and Red Hat Enterprise Linux serves as both a tutorial and an on-the-job reference. You'll learn to use GUI-based tools, the command line, and Perl scripts, and how to set up key Internet servers. How do you win this book? Simply answer one of five questions and post...

    MelanieYarbrough6,345 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