• Implementing Encrypted SQL Server Database Columns

    This is the problem I'm facing: The database (SQL Server 2005) holds more than 5 million customer records. These records contain sensitive credit-card information that must be encrypted. Implementing an application-side encryption solution involves VB6 and .Net technologies. How to achieve a...

    Kansai5 pointsBadges:
  • Failure to register an SPN in SQL Server

    Event Type: Information Event Source: MSSQLSERVER Event Category: (2) Event ID: 26037 Date: 07/07/2008 Time: 07:37:40 User: N/A Computer: Computer name Description: The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x2098,...

    Tiz5 pointsBadges:
  • How to create date in SQL Server 2000

    I created a table with attribute date and i want to store date as "Date-Month-year". What procedure to create a date and how we able to insert the required format by using SQL Server 2000?

    Malikjavediqbal30 pointsBadges:
  • Implementing a test system with SQL Server log files

    We need to implement a test system where the entries created in various tables on a test server need to be automatically re-generated on a live server so that there are no manual errors. We think the only way to do this is to use SQL Server log files. However, we are not sure that the tools...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Copy SQL Server Table

    How do I copy a table into the same database without including the data? Thanks ken

    Ilfoprog50 pointsBadges:
  • Column extention in SQL

    Hi I want to expand the number of columns that SQL would permit me to create. How do I start? any suggestions? example: 1032 maximum column limit I want in the area of upper 5000 range for a table. Someone help. Thanks!

    Ctc12320 pointsBadges:
  • SQL Server 7 database restore

    I'm working with SQL Server 7 and I made a backup from a Database and I need to restore it, but this error appear: "The RAID set for database is missing member number 1". What can I do?

    Claudiofuentes15 pointsBadges:
  • Deleted SQL Server 2005 database

    Hi, actually I know the importance of backup, but I don't have the back up in any-how condition. Accidentally the database deleted by me. How do I recover it? How to use the transaction.log file to restore deleted database in SQL Server 2005?

    Lalit35 pointsBadges:
  • Advantages and disadvantages of certain SQL commands

    Where can I find information about the advantages and disadvantages of using SQL commands like BCP, BULK INSERT, SELECT INTO, etc.?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Date formats in SQL Server Stored Procedures

    This one will be easy, I'm sure. I'm a novice at Stored Procedures, and I'm wondering what function I can use to display a smalldatetime field (currently displaying as Dec 19, 2008 12:00AM) as a short date (12/19/2008)? I am on SQL Server.

    Wandasoozq5 pointsBadges:
  • Eliminating Nulls in T-SQL

    If I want to return null values in a query that has "Where Field1<>'test' is there an option I can turn on? Example: CREATE TABLE myTable(Field1 varchar(25)) GO INSERT INTO myTable VALUES ('test') INSERT INTO myTable VALUES('test2') INSERT INTO myTable VALUES(null) GO Select * From myTable...

    TJay85 pointsBadges:
  • Being notified when a delete operation is performed on SQL Server

    How can I be notified of delete operations in SQL Server? Is there a tool out there (or something) that will notify me when a user performs a delete operation, without the user knowing about this activity?

    SQL Server Ask the Experts2,585 pointsBadges:
  • ASP.NET

    I have four textboxes and a database which is already created. What I want to do is if i enter the value in the four textboxes and press button, it should automatically gets updated or saved in the database.

    5555544425 pointsBadges:
  • Creating a username and password on a SQL Server database

    How we can create a username and password on my SQL Server database?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Connection of Crystal Report 2008 with VB6.

    Please let me know the procedure to bring the controls of Crystal Report 2008 in VB6? What control has to be select and what coding should be use for the same? I'm using SQL 2000 as a back-end. Please help.

    Anishrohlx5 pointsBadges:
  • Create aggregate tables in SQL Server

    Hi TechTarget Artifacts, How can we Create aggregate tables? Can you please tell me the Syntax? Thank you

    Srinivasreddysap5 pointsBadges:
  • Hibernate with clob type

    I am using clob of oracle 10 g in hibernate. When I tried to insert 5000lines of HTML code to the variable in Java, I'm getting the following error; Caused by: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not insert: [com.citi.gicap.bpm.ver.domain.Notes];...

    Arunpmk5 pointsBadges:
  • Convert time to GMT time

    In T-SQL, I want to store the date from the getDate() function in GMT time instead of local time.

    Apinto5 pointsBadges:
  • Free Chapter – Beginning Spatial with SQL Server 2008

    Another free chapter download is available on the IT Bookworm Blog. Written by: Alastair Aitchison Book: Beginning Spatial with SQL Server 2008 Overview: "Microsoft SQL Server 2008 introduces new geography and geometry spatial datatypes that enable the storage of structured data describing the...

    BrentSheets6,925 pointsBadges:
  • How to backup a SQL Server database

    Hello, I wonder if you can help. We are just about to start implemetation of SQL 2005 Server. Can anybody, let me know how we go about backing up the database? We have veritas 9.1 but I guess we need to back-up live if possible. What is our best option?

    Garrybreed45 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