• sql server 2005 mirroring

    i have 2 servers, with sql server 2005 standar version, running mirroring, can i see if the data is being updated? how know that? can i make backups while running my mirroring?

    RaulZ5 pointsBadges:
  • Importing SQL Server 2005 tables from one server to another

    My developers want to make a copy of a SQL Server 2005 database from one server to another, but due to company policy, I cannot give them the restore permission. So, as of right now, they are importing each table, one by one, from one server to other. Is there a way to import all of them at once?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Spoolersp.exe Error occuring frequrently in Windows 2003 environment running a VB application.

    We are running a VB Application in Windows 2003 environment. The database Server is SQL 2005. The Application runs in a separate server and the database in another. Remote Users connect to the application through the Remote Desktop facility. Users can go for direct print as well as save to PDF and...

    Ravikswamy35 pointsBadges:
  • Migrating SQL Server 2005 back to SQL Server 2000

    How would I go about migrating SQL Server 2005 back to SQL Server 2000?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Convert SAS to Stored Procedure

    How do I convert a SAS job into a Stored Procedure to run on MS SQL Server 2005?

    VelameLaCosa110 pointsBadges:
  • Restoring a database after migrating from SQL Server 7 to SQL Server 2005

    I am trying to migrate from SQL Server 7 to SQL Server 2005, but when I try to restore the database I get this error: "Processed 120424 pages for database 'COAST', file 'Coast_Data' on file 1. Processed 1 pages for database 'COAST', file 'Coast_Log' on file 1. Converting database 'coast' from...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Figuring out the SA password in order to upgrade to SQL Server 2005

    I am upgrading my firm’s legal software to a version that uses SQL Server 2005. We are on a Windows 2003 Small Business Server, and SQL Server was installed before I started at this firm. My new software needs me to login as the System Administrator. I cannot seem to do that, as I do not know...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Corrupting database in an VB.NET application in SQL Server 2005

    I have a application in VB.NET with SQL Server 2005 Express Edition. In the last few days, the database is continuously corrupting. I repair it, but the problem continues. I revise my code, but I can't find transactions errors that could produce the problems. Do you have any general ideas?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Moving data from one DB to another DB in SQL Server 2005

    Hi all I got formula to calucalate Row_size of a table Row_Size = Fixed_Data_Size + Variable_Data_Size + Null_Bitmap + 4 Fixed_Data_Size = total byte size of all fixed-length columns Variable_Data_Size = 2 + (Num_Variable_Cols x 2) + Max_Var_Size Num_Variable_Cols = number of variable-length...

    Snivas20 pointsBadges:
  • Index Strategy for existing SQL Server 2005 project

    Hi All I Newly joined with new Project,My Boss told me that Create Index strategy document which in excisting Project. I don't where to start. I prepared some documents which is basically saying about Index recomandation,When we have to creat Indexes,and so other stuff which is finding most used...

    Snivas20 pointsBadges:
  • SBS 2003, SQL Server 2005 and database mirroring

    Hello! I m trying to get db mirroring to work between two sbs 2003 premium based sql (2005) servers. Am I just plain stupid or did I miss sth? And please dont tell me about traceflags becaouse they dont seem to have an effect on my ... problem? Perhaps I came out as a bastard but Im in a realy bad...

    Bljahvljah30 pointsBadges:
  • SQL Server 2000 Enterprise Edition upgraded to SQL 2005

    I am researching different Hosting companies with dedicated servers that we can look at moving to. I need to know some information when I am looking at these different companies about the SQL server. We are currently running SQL Server Enterprise 2000. I have seen that the companies are offering...

    Gauravpadia5 pointsBadges:
  • Error when restoring a SQL Server 2005 database

    Every time I restore one of my SQL Server 2005 databases to a point in time, my log shipping restore job fails on my secondary server. Any ideas on how to correct this?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Assigning data distributions to SQL Server 2005 databases

    In SQL Server 2005, we have two databases. We want the first one to store tables, and the second one to store views of the tables in the first one. We have achieved this if the tables and views are in the same database, but is there a way to do it with two?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Multiple instances with SQL Server

    Is it adviceable to put SQL 2000 and 2005 in one single CLuster by putting them in different instances?

    IMR5 pointsBadges:
  • Executing DTSX from VB.NET 2003

    We converted form SqlServer 2000 to 2005. We had dts packages which were used to import Excel data into the database. We re-created new dtsx packages to replace the old dts packages where they sit on a local drive. Our VB.NET 2003 application used to be able to run the old dts packages but we...

    BClawson10 pointsBadges:
  • Linked servers from SQL 2000 to SQL EXPRESS 2005

    I wanted to create a linked server on SQL SERVER 2000 to SQL EXPRESS 2005.Both servers are on the same machine .SQL SERVER 2000 using username and password while SQL EXPRESS using integrated security.Thanks in advance.Any one let me know how to create this?

    Pdeevi5 pointsBadges:
  • Inserting rows and multiple rows in SQL Server 2005 Express

    Anyone there who can help me solve my problem? I can’t continue my program because of this problem which I know someone can solve or can suggest the best possible solution. I have a project in my study doing simple accounting program. To facilitate the discussion, I will just show you the three...

    Ariell5 pointsBadges:
  • Error when updating SQL Server 2000 from SQL Server 2005

    Hi, I am using sqlServer 2005 and sqlServer 2000. When i update on sqlServer2000 from sqlServer2005 then following error was occured. Msg 682, Level 22, State 148, Line 1 Internal error. Buffer provided to read column value is too small. Run DBCC CHECKDB to check for any corruption.

    Nileshpatkar825 pointsBadges:
  • System tables in SQL Server 2005

    What is the role of system tables in SQL Server 2005 and how do you update them?

    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