• Instance specific error when connecting to SQL Server

    What is instance specific error? It is occuring while connecting to SQL Server  ... how can i fix this error?

    FAIZAHAFEEZ5 pointsBadges:
  • What data should be stored in SQL Azure and Table Storage?

    My team and I are in the planning phase for the typical social networking type of a web application. It includes profiles, messages, chats, groups, albums, etc. But now we're trying to figure out the deciding factors on what data should be stored in SQL Azure and what should be stored in Table...

    ITKE54,820 pointsBadges:
  • Restore a SQL Express 10.0 database

    How can I restore a SQL Express 10.0 database on SQL Express 10.5?

    sam4umore5 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:
  • Set up retention policy for deleted items folder on Exchange 2007

    How to set up retention policy for deleted item folder on exchange 2007? I would like to run the policy to empty the folder based on item age. Thank you.

    X4y10 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:
  • Getting ORA-29283 error when opening CSV file using UTL_FILE.FOPEN

    I have a SQL script and all it does in to open a CSV file using UTL_FILE.FOPEN. I keep getting the ORA-29283 error.  I have an Oracle directory object pointing to the file location. Here is the code snippet: create or replace procedure "SKINNY" as v_inputfile            ...

    jkeri355 pointsBadges:
  • What is a File copy limit in Windows XP?

    Does any one know what is a copy limit in windows XP as when we copy a lot of small files Windows XP stations come up with low resources error ex. we copy 40GB=800000 files windows 2003 server edition is fine no problems.

    Dimchik0 pointsBadges:
  • Import data from Access into SQL Server 2005

    Hello, I have a large database on ms access with more than 100 tables. I am planning to do migrate this database into MS SQL Server 2005. I am receiving info into database access on a daily basis. So I have to do an auto job to import data from access into SQL Server 2005. I think that creating a...

    7715 pointsBadges:
  • Do extra spaces affect disk space size?

    I currently have over 147 columns in a SQL Server database (with the majority of them as VARCHAR). This data is imported from our agency and for extra fields, they all include spaces in the field instead of entering an empty string / NULL. I just ran a script that would covert all those columns to...

    ITKE54,820 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:
  • Ghost imagaing

    Hiya all, Specs first.. Ghost Corporate multicast server 7.5. Switches are all 3com, 10/100. Wireless network is 10mg network ports (2) shared via 2 wirelss access points, (D-Link 22Mbps) Problem is, whenever i image multiple machines, the whole network goes slow. The machines affected are old and...

    Carl0s810 pointsBadges:
  • Creating a new database using an MDF file

    My database saves as MDF. I want to know what are the steps to restore or create a new database using a MDF file? I tried to restore as usual but it shows an error. Please help.

    Thrstorm5 pointsBadges:
  • Behaviour of Service Broker during clustered SQL Server failover

    Hi, I have 3 instances of SQL Server 2005 hosted on a 3-node cluster, using Polyserve clustering.  Each instance is nominally hosted on its own node in the cluster. I have configured Service Broker to route messages from INST-A (on NODE-1) to INST-C (on NODE-3), using TCP and a NetBIOS name....

    SimonNZ5 pointsBadges:
  • Open IT Forum: What do you want to see from IT Knowledge Exchange in 2012?

    We asked what your goals are for late 2011 and early 2012, but now we want to know what you hope to see from the IT Knowledge Exchange community. If there's a functionality you would like to see, or a topic you want to know more about, let us know in the discussion section! Don't be afraid to get...

    MelanieYarbrough6,345 pointsBadges:
  • Adding a field when using SQL to copy a file on iSeries

    My company is upgrading some applications and I need to copy the data from current files into the new files. In some cases the new files have additional fields. Is there a way with sql to copy the current data and at the same time add either a default value or a running sequentional value to the...

    CLK35 pointsBadges:
  • Errors in creating database in SQL Server

    While creating a database in SQL Server I got error as: an exception occured while executing a transact-sql statement or batch microsoft.sqlserver,express.connection-info create database permission denied in database master Can anyone tell me how to proceed?

    velankinipriya5 pointsBadges:
  • P2V Windows XP SP3 SQL Server 2005 Express

    Hi all, can I do P2V with Windows XP SP3 and SQL Server 2005 Express? Is that is possible and how? I mean what kind of software if its doing cold or hot?

    Fulgen5 pointsBadges:
  • Exporting vb6 data to pdf using sql select query from ms access .

    hi my name is vishal. I think i have a problem in exporting vb6 data to PDF using sql select query(join query from multiple tables). i have a form in which when user selects a GRNno from combobox and then press button with caption:Generate it should generate a PDF report regarding GRNno.Given below...

    Ametuer30 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:

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