1
  • Cannot connect VB program with SQL Server 2005 in local machine

    The simple program of fetching the data of table through vb.net program. I am retrieving the data into DatagridView . I am writing following String str for connection: Dim str As String = " Data Source=COMP1SQLEXPRESS ; Initial Catalog=Atuldb; User Id=COMP1comp11;Password= " my database name is...

    AtulMCM5 pointsBadges:
  • SQL Server Management Studio Express 2005

    I have installed Studio Express on my system but I am not able to start with it. I am not able to connect to the server. Error-40 and Error-26 is coming.What is the procedure to connect?

    Sweetu20 pointsBadges:
  • Connecting to a SQL Server 2005 database through LAN

    I am trying to connect to my SQL server 2005 database on my server. I open SQL server 2005 management studio and try to set the server name to IPADDRESS\SERVER3 (the name of the server) but this doesnt work. I have also tried with connection strings in VB and these dont work either

    Providence15 pointsBadges:
  • Can anyone tell me the best way to query Active Directory in SQL?

    Can anyone tell me the best way to query Active Directory in SQL? I'm using SQL Server Management Studio Express and want to add the LDAP server for AD as a linked server to query. I'm not sure what the best way to do this is.

    Eabouzeid175 pointsBadges:
  • Bulk Insert Problem in SQL Server Management Studio 2005

    Hi. I'm running into an issue performing a bulk insert. I've taken the following steps: Created a tableCreated a schema file with a .fmt extensionCreated a stored procedure to insert a file When I attempt the bulk insert I get the following error message: Cannot bulk load because the file...

    Eabouzeid175 pointsBadges:
  • Developer Access to Sql2005 Management studio

    In sqlserver 2005, many tools were integrated into the management studio. How do you limit access to portions of the manaagement studio, such as only allowing devleopers access to the query analyzer, while allowing Administrators full access to all tools?

    Justadeveloper5 pointsBadges:
  • Moving a database from SQL Server 2000 to SQL Server 2005 and back again

    I moved my database from SQL Server 2000 to SQL Server 2005, but now, if possible, I'd like to move it back. When I open SQL Server Management Studio 2005 and check my database's properties, its compatibility is "SQL Server 2000(8.0)". Can I move my database back to SQL Server 2000, and if so, how?

    SQL Server Ask the Experts2,585 pointsBadges:
1

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