• Database Newbie

    I'm quite new to database security and MS SQL server 2005 and 2008 and was hoping to find some extra sites or books to help as I am currently writing an application to send OS info and service tags to our SQL server. I obviously can t have the SQL server directly on the internet with an open port...

    Neutrino40 pointsBadges:
  • Integrate MOSS with SQL Server 2008

    Can someone provide a step-by-step or point me to a guide for integrating MOSS with SQL Server 2008? Thank you very much. Moderator Note: This is a submitted question

    BrentSheets6,925 pointsBadges:
  • SQL Server Fails to Start When Moved to Different Node

    Sql 2008 R2 on Windows 2008 R2 cluster. When I move instance from node 1 to node 2 everything is fine: all resources come online as they should. When I move the instance from node 2 to node 1, all resources except sql server and agent come online. If I delete errorlog and start the sql server...

    Spadasoe5,130 pointsBadges:
  • SQL server 2008 downgrade to express

    Due to our budget we are being forced to downgrade some servers from SQL server 2008 R2 to Express. Was told it 's a saving of 20k per PC.Are there any issues that we need to know that may cause us problems? I know Microsoft does not make downgrades easy.. If anyone could shed some light I'd...

    ToddN200011,820 pointsBadges:
  • Moving SQL Server database without affecting VB 6 code

    I am using VB 6 code with Microsoft Access database. Now I want to move to SQL Server 2008 database without affecting my VB 6 code. Any suggestions?

    vikasjains20 pointsBadges:
  • Installing SQL Server 2008 and VB 6 on the same PC

    I have 1 pc.3 drives-c:,d:,e:. Now I want to install SQL Server 2008 and VB 6 on the same PC. Mean to say Can I make use of SQL Server 2008 with VB 6 on same machine?

    vikasjains20 pointsBadges:
  • My database .mdf file got corrupted in SQL Server 2008

    My database .mdf file got corrupted and I have no means to get my schemas. I tried with a few softwares available on the internet but its turns out that with all of them being demo versions, I don't give back the repaired file. Is there any other means by which I can restore my db? I am using MS...

    mjozekh5 pointsBadges:
  • Crystal Reports 8.5

    I have a report that uses SQL 2008 database. It is a money field. I do not want the decimal or the $ sign to show. If it has cents like 1.50 I want it to appear as 150 if it is just 1.00 I want is to be 100. How do I accomplish this?

    llplora5 pointsBadges:
  • Best value for fillfactor in SQL?

    What is best value for fillfactor in SQL?

    mukeshkumar1210 pointsBadges:
  • How to find a word starting with (‘a’,’b’,’c’,’d’,’e’ or ‘f’) and end with ‘z’ from table.

    How to find a word starting with ('a','b','c','d','e' or 'f') and end with 'z' from table.

    mukeshkumar1210 pointsBadges:
  • Disk Partitioning w/SQL Server 2000/2005/2008

    I recently read some information regarding aligning the Disk for use with SQL Server from Mr. Denny. My understanding is, SQL Server handles data in chunks of 64KB, so the disk drive SQL Server writes to containing data and log files should be configured to work in 64KB chunks. The articles I am...

    JohnMCouch5 pointsBadges:
  • SQL Server 2008 database backup terminating abnormally

    I'm running this code for backing up and to have backup log: backup database adventureworks to disk = 'g:radvent6.bak' mirror to disk='g:radvent7.bak' with format,checksum,stop_on_error use adventureworks insert into HumanResources.department (name,groupname)values('dreee','reserch') backup log...

    Tablestructure15 pointsBadges:
  • How many users can access the file stored on SQL Server 2008?

    After we store any file on our SQL Server 2008, how many clients will able to access that particular file from the server at a time?

    NikhilGaikwad5 pointsBadges:
  • connect sql server with tcp/ip how can i do?

    connect sql server with tcp/ip how can i do?

    DangerM5 pointsBadges:
  • Establishing a connection from an IBM DB2 database

    I've been trying to establish a connection with an IBM DB2 database (from which I can extract data). Here are some of the details I have:Server NameData LibraryUsername/PasswordI've used both Microsoft Excel and SQL Server 2008 but neither way is working. Using Excel, this is what I tried: I have...

    ITKE347,940 pointsBadges:
  • Apps built on SQL Server 2005 running in 2008?

    Will applications built in SQL Server 2005 run in a SQL Server 2008 environment

    jwover5 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...

    ITKE347,940 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.

    ITKE347,940 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:
  • 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