• SQL Server: Insert number of rows into a table

    I have a SQL Server database where I currently upload files into a staging table. On the table, I have 2 JOINs that corrects foreign keys. That's followed by putting these rows into one final table. Right now, there's roughly over 3 billion rows of data. Now here's my question: What's the best (or...

    ITKE380,540 pointsBadges:
  • How to fix a SQL Server database that’s stuck in a restoring state

    Our department currently has a SharePoint server. But our network administrator mis-configured the backup tool (it was Symantec Backup Exec) and several of our SQL Server databases are stuck in restoring state. What should we do? Can we get these databases back?

    ITKE380,540 pointsBadges:
  • How to tell if my SQL Server database is still in use

    We have to get rid of a SQL Server instance (basically decommission it) but it still has several databases left on it. Is there a way to tell if these databases are still being used by our users? Thank you very much.

    ITKE380,540 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:
  • SQL Server: Should I have auto-shrink turned on?

    This is a basic SQL Server question, but for my database, should I use the auto-shrink option. But someone told me it's not really secure. Is that true?

    ITKE380,540 pointsBadges:
  • Can I add a dependency to a Windows Service?

    We currently have a Windows Service that's using a SQL Server database. I don't have control over it (my boss does) but he asked me to add a dependency so it starts up after SQL Server starts up. Can I do this? Is there a specific tool I have to use?

    ITKE380,540 pointsBadges:
  • Delete all tables in SQL Server database?

    How to delete all tables of a database in SQL Server?

    Prcvjr220 pointsBadges:
  • How can I restore a database from .mdf file?

    How can I restore a database from .mdf file? I only have .mdf backup file.

    SQL Server Ask the Experts2,585 pointsBadges:
  • Problem with SQL Server Database File(.mdf)

    I am using SQL Server 2008 R2 and I want to check my master database file (.mdf) but failed to open it.

    edwinjhoffer3,140 pointsBadges:
  • How to view content damaged MS SQL Server database?

    Help! Dead computer and all the information. Computer to reinstall formatting (otherwise failed). With the help of programs to restore files managed to pull Fail SQL database (.mdf). But on the other computer does not accept the file. Writes an error. Already tried everything. How do I restore the...

    hanamor11005 pointsBadges:
  • How do I convert a text file into SQL server database table using Visual Basic 6.0?

    Can anyone tell me how do I convert a text file into SQL server database table using Visual Basic 6.0?

    Iaquinto5 pointsBadges:
  • Need project plan for Access 2007 database migration to SQL Server

    Does anyone have a project plan for Access 2007 database migration to SQL Server?

    Anflores5 pointsBadges:
  • What type of Raid to use on Windows Servers and tempdbs?

    I have a SQL Server with eight disks, and I am not sure if I should use Raid 10 twice, one for Windows Server 2003 with NDFs and the other for the log file and tempdb, or apply Raid 1 for the Windows Server, Raid 10 for the NDF and MDF, and Raid 1 again for the tempdb and log. What would you...

    SQL Server Ask the Experts2,585 pointsBadges:
  • I want to create backup of SQL database and set a password.

    HEllo All  i want to create backup of SQL database and want to set Password that anyone who restore this backup after that it cant be able to restore database without knowing perticular Password .... is this Possible....? if Yes please tell me How...? Thanking You Raviraj

    Raviraj1235 pointsBadges:
  • Porting MS Access database to SQL Server

    I've got a problem with porting my MS Access database to SQL Server. In my inventory database, I have 4 tables: (1)Purchase, (2)Sales, (3)Quantity Adjustment, (4)Amount Adjustment. I want to calculate the stock position from those 4 tables. In access database, I do with this kind of queries: a....

    Ipong40 pointsBadges:
  • Restoring SQL databases

    Sir, I have deleted a table in SQL database. Is there any option to recover it without losing the data. Please reply.

    H1005 pointsBadges:
  • Transferring a database from Microsoft Access to SQL Server 2000

    How would I transfer a database from Microsoft Access to SQL Server 2000?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Removing and adding new space to databases

    The scenario: SQL_SVR_A (2000)has x amount 'too much' SAN disk space that they want to reclaim/use to allocate to SQL_SVR_B (2000)- which doesn't have enough space. What is the best method to, first, remove the disk space and keep all DBs in-tact and secondly, how to add new space to ServerB,...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Re-linking SQL Server database user

    Hi Guys, What I am trying to do is relink a database user to a new domain user, and also keeping the same database user name. I am able to do this when I run the following command, and if the database user isn't the same as the login name. use temp alter user TestUser2 with name= TestUser2, login=...

    Db23290 pointsBadges:
  • Restoring a SQL database with an .mdf file

    How can I restore a SQL database with an .mdf file?

    SQL Server Ask the Experts2,585 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