• Backup/Restore a DB from Microsoft SQL Enterprise Manager to SQL Server Management Studio Express

    Hi Is it possible to copy a DB from a server that has a genuin SQL Enterprise Manager to a server that has SQL Server Management Studio Express installed? Both servers are on the same net. I get following error when trying: Restore failed for Server 'PROGTST\SQLEXPRESS'....

    Lissy5 pointsBadges:
  • RAID 1 or RAID 5

    I have 1 file server and 1 email server. both are Win2k3....one with exchange 2003 one with SQL 2000 but only 4 people using a small accounting program on it. Both are Dual XEON 2Ghz processors 1 Gb RAM 15K rpm hard drives. Ultra SCSI 160 controllers File server has software RAID 1, Exchange Server...

    TheVyrys0 pointsBadges:
  • Installing SQL Server over a SAN

    I am trying to install and configure my SQL Server over my Storage Area Network (SAN). Can you give me the best steps for doing so?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Time out in VB.net when SQL transaciton log backup schedule changed to hourly

    We have changed our back up schedule on transaction log from daily to every hour recently. Now my VB.net 2005 program start getting fail to read the table error (maybe caused by Timeout) during the time backup is executing. Is there anyway we can prevent this? Thank you, Paul Hsu

    PaulCHsu0 pointsBadges:
  • Oracle to SQL Server Migration – User Defined data types

    Oracle database has two user defined types as the following: CREATE OR REPLACE type arrayType1 is table of int CREATE OR REPLACE type arrayType2 is table of varchar2(255) How do we represent these in SQL Server 2005?!! (Note: Microsoft SSMA fails to migrate these) Thanks

    Kumar937825 pointsBadges:
  • What are the benefits of SQL Server 2005 over SQL Server 2000?

    If i am satisfied with SQL 2000 then why I should go for SQL 2005

    Itramkrishna5 pointsBadges:
  • SQL server – Stocks Data -How to Push Data To Client Application

    My client application providing real time stock quotes takes data using a xml webservice which pulls data from sql server 2005.with number of clients increasing for same piece of data, the sql server is being queried again and again.Is there a way to push data from sql 2005 to client application...

    Rak9995 pointsBadges:
  • Too many XP profiles

    We have over 100 XP local profiles on our library machines. The users use thier own respective usernames to log onto our domain. We dontnor plan on using roaming profiles. Is there a way to delete the local profiles quickly without doing them one at at time? Is there a way to limit the number of...

    Kellarm0 pointsBadges:
  • Oracle to SQL Server Migration – CURSOR type conversion

    When I migrated a small database from Oracle to SQL Server using Microsoft SSMA, it converted CURSOR types to varchar(8000) **SSMA Warning** O2SS0259:CURSOR type was converted to varchar(8000) ** Do we just leave this as is or does it require attention. Thanks.

    Kumar937825 pointsBadges:
  • SQL Integration with Oracle10g

    have created a link between our Oracle DB and SQL server db it was succussfulty created and i was able to select data from oracle table using SQLServer. then i have created a view in sqlserver using this link to read from Oracle, the view was created create view dah_test as ( SELECT count(*) as...

    Kmadani35 pointsBadges:
  • Error message in Reporting Services on SQL Server

    I am trying to post a report on Reporting Services on SQL Server, but I keep receiving this error message (“salesexpo1” is the name of the table): An error has occurred during report processing. Query execution failed for data set 'rSellingEP_AV'. Invalid object name 'Saleexpo1'. What might...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Moving from single server to multiple servers

    Hi all, We have a Single Windows 2000 server (Back office edition, configured as a Primary domain controller). It has SQL server 2000 running, which serves a bespoke database application. The server is also used as a simple fileserver for documents, etc... We do not use Exchange Server. I need to...

    Michaeltwozero0 pointsBadges:
  • SQL 2005 to .XML

    How do I automate 2 sql servers to replicate .xml files

    Camofa5 pointsBadges:
  • sql server 2005 slow

    Several times during the day SQL Server 2005 Express is becoming very very slow (actually freezes), even if there was no activitry at all. After restart it is normal again for a couple of hours, then freezes again.

    Vad20 pointsBadges:
  • Why sqlcode error=100 comes ?

    sqlcode error=100 comes. The required fields are being populated in table. Still why i am getting this error ?

    NAVIN5 pointsBadges:
  • How do you install SQL Server Enterprise Manager?

    how can installed SQL Server Enterprise Manager,

    0805198220 pointsBadges:
  • DTS Package Schedule runs only once, Status shows executing

    Hi, I have set up a DTS Package and schedule it to run every 2 minutes (to prove it will run regularly). Unfortunately the package only runs once. The process only takes a few seconds. The job status shows "Executing Job Step '1 DTS Package1'" Is there something I'm missing? Gabs

    Gabs15 pointsBadges:
  • SQL Server 2000 Log File Size is increasing

    I have a sql server 2000 where log file is increasing very fast. My mdb file is 600 MB and Log file 6GB. How can i reduce the size of the file. Shrinking the file is not working.

    Ynaina5 pointsBadges:
  • LDF size reduction

    How can reduce *.LDF size i have run the command dbcc shrinkfile (Filename,1) but could not reduced.

    SAP Cum IT35 pointsBadges:
  • ASP.net profile object

    I attempted to use the profile object as described in a training video; however when I hit f5(to execute the app in debug mode) the browser begins to opens up but I end up with the debugger telling me it cannot open SQL Server. According to the video the Profile object will default to "string" if...

    Alemap5 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