• Critical Error in Security Log

    All, I manage a Windows 2003 Small Business Server Network with 9 clients. The server provides all network services. We use Logon/logoff, shared storage, and print server functions. We do not use exchange except for the server reporting tool. We do use about 4 instances of SQL. All clients are...

    FlyNavy0 pointsBadges:
  • Free IT Book: CompTIA Security+ Certification Passport

    This week's free IT book is Mike Meyers' CompTIA Security+ Certification Passport: Revised for the new CompTIA Security+ exam (SY0-301). The new edition provides a condensed and concise review of CompTIA’s well-established security credential. For a chance to win this quick review, cram-style...

    MelanieYarbrough6,345 pointsBadges:
  • Free IT Book: The Accidental Administrator: Cisco ASA Security Appliance

    This week's free IT book comes with a bonus interview with the author, Don Crawley! Check out what he has to say about the book, the process, and the joys of being an IT-type personality. Then answer one of the questions below and post the link to your answer in the discussion section for your...

    MelanieYarbrough6,345 pointsBadges:
  • SQL 2000 migration to SQL 2005 – need to preserve user security

    Hi, I have a customer that is planning on moving to new hardware and performing a SQL upgrade (2000->2005).  I know that our application (FileNet Image Services) is sensitive to what we refer to as an "orphaned" database.  Our app stops working if a database is simply detached/attached to...

    Vitomizer5 pointsBadges:
  • SQL 2005 Security to access 2 databases on same server via Stored Procedure

    We are tyring to apply best security practices by only granting EXECUTE security to Stored Procedures connected to a Role and make users members of the role. However the SP needs to access data from another DB on the same server and when trying we receive "SELECT permission was denied on the...

    A00001615 pointsBadges:
  • Home Dir Security and file sync aka CSC

    I having issues configuring Home directory file sync. After I configured folder redirection by MS recommendations, I receive a folder permissions error when I right click on a file and tell it to sync. Following MS's white paper on configuring redirected folders,...

    JEAKINS0 pointsBadges:
  • import excel data into multiple table through ssis

    Hi All,currently i have requirement as i have import button on my front end application. when client click on that button it will browse the path of excel file and then import the data into table.remember that excel data need to fill into multiple tables.example i have 25 column of excel sheet and...

    ManishDB5 pointsBadges:
  • Evicted Last Server from 2003 Cluster – Databases won’t start

    **First submit blanked out all the original content** Sorry Environment - Windows Server 2003 SP1, SQL Server 2000 .exe version 2000.080.0760.00 I am helping to remove the clustering and migrate all databases on the cluster to a single machine in the cluster. I was able to evict Server 1 from the...

    MaxxOC5 pointsBadges:
  • Clustered index in SQL Server 2012

    A clustered index is created automatically in SQLserver 2012 while creating a table with primary key. The index is created on the primary key field. My queries which are not using the primary key for search are costing 100% on clustered index scan. Should I create covered index for each and every...

    dhanam115 pointsBadges:
  • Function Execution in Select Clause

    I stuck in a scenario. Can somebody help me out. I have a table contains column Id, FncName Id column contains integer value and FncName contains Scalar Function name. I want to select a row from table and in result set I need the result of execution of that function. Sample data is given below:...

    luckysaad00015 pointsBadges:
  • Source code for multiuser programming in VB 6 with SQL Server 2000

    hi to all, I'm developing a security software in Vb 6.0 with Sql Server 2000 as back end wherein 10 users will be there. I'm a newbie in multiuser programming. The question before me is that how to proceed further. My stand alone code is almost ready 50%. I'm using Ado for establishing connection...

    Isha5 pointsBadges:
  • Pros and cons of running SQL Server 2005 through virtualization on VMWare

    I have been asked to provide pros and cons for running SQL Server 2005 on one hardware (VMWare) for multiple groups of DBAs. The proposed plan is to have SQL Server 2005 Standard Edition with system administrators managing the server and DBAs not allowed to logon directly to the server (only...

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL 2000 & Outlook 2000

    We have a couple of SQL 2K Servers which have a mailbox associated with them, have always used Outlook 2000 because anything newer does not work and today it has gone wrong!!! We are now getting a "Cannot open the mailbox, information store not available" we cannot get the server to work with email...

    Paulbeynon60 pointsBadges:
  • SQL Server view column conversion problem

    I have a view with a column SWID. The source column is Varchar while in the view creation it has been cast to INT. The source table has a non-numeric value "CITY", while during the view creation, this record have been filtered out. When I select all records from the view, it's working well....

    Rmb19815 pointsBadges:
  • Should we use Hyper-V snapshot for backup on SQL Server 2008

    So we have SQL Server 2008 in Hyper-V as a supported configuration. It's been performing well since we're using fixed or pass-through disks (which has increased our processor/memory settings). My big question is can we use snapshots as a reliable backup mechanism? Should we use the tried and...

    ITKE346,465 pointsBadges:
  • Trying to get rid of “divide by zero” error message using SQL Server 2008

    In SQL Server 2008, I keep receiving this error message: Msg 8134, Level 16, State 1, Line 1 Divide by zero error encountered. Now, this is more of a general question but what is the best way to write SQL code so this message will never appear again.

    ITKE346,465 pointsBadges:
  • Free Chapter – Hardening a SQL Server implementation

    Another free chapter download is available on the IT Bookworm Blog. Written by: Ross Mistry and Hilary Cotter Book: Microsoft SQL Server 2008 Management and Administration. Overview: “If you need to deploy, manage, or secure Microsoft SQL Server 2008, this is the complete, fast-paced, task-based...

    BrentSheets6,925 pointsBadges:
  • SSIS 2008

    I have a package with 5 data flow tasks and want to run them parallel. If any task fails, should the others still be executed and the task that failed, an email should be sent out.

    shaun20145 pointsBadges:
  • Advantages and disadvantages of clustered indexes

    What are the advantages and disadvantages of clustered indexes?

    SQL Server Ask the Experts2,585 pointsBadges:
  • High LATCH_EX wait

    What is LATCH_EX wait? Our LATCH_EX wait is very high. What do I need to look at to fix this?

    Rick Martinez585 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