Search results for query: *

Thanks for your help, it worked like a charm.

The server and workstations are within the same building. What is the normal/best method of maintaining the server databases? Is the installation of Query Analyzer on a workstation fairly straight forward?

Ahha. I was missing one of the security settings. Its working now. Thanks.

I am very new to SQL. We have a SBS 2003 with SQL installed. I currently use Remote Desktop from my workstation to query and maintain the server databases. Can I install the Client Tools (Query Analyzer and Enterprise Manager) onto my workstation and attach to the server? Preferably without...

Thanks for your quick response. I am very new to VB and SQL programming. At this point I have only tried to establish the connection through the solution explorer. I can see the server but cannot make a data connection. I have been able to create Crystal Reports with the server data using VB...

I am using VS 2005 and cannot get a connection to our SQL databases in 'Solution Explorer'. I can see the server name listed but I cannot connect to any database. I have set all of the permissions I can find in Enterprise Manager.

You might also want to take a look at www.LearnVisualStudio.Net, it has several good videos on a variety of subjects for both VB and C#. And it is pretty reasonable in price.

Nevermind, I may have figured it out. For anyone in the future with the same problem. I first followed exactly the steps in the "Microsoft SQL Server: Programming FAQ" "using NT Authentication to login into SQL". I am not sure if that helped as I am fairly confident I had the proper...

I have a VB 2005 project with a DataGridView linked to a SQL2000 Server (SBS2003). When I debug the application without saving the project, it runs perfectly. After I save the project, I get the following error. Request for the permission of type 'System.Data.SqlClient.SqlClientPermission...

I have a VB 2005 project with a DataGridView linked to a SQL2000 Server (SBS2003). When I debug the application without saving the project, it runs perfectly. After I save the project, I get the following error. Request for the permission of type 'System.Data.SqlClient.SqlClientPermission...

We receive electronic invoices from several customers into a specific directory. The file structure is consistent, but the file naming conventions are not. Inlcuded within the file, is the customer number. We currently have a clipper program listing the directory files to the screen and...