Hi Bob

I'm a man. Florian is a German name. Maybe you know Munich (Bavaria). The city with the "Oktoberfest" 😉

Greets

Flo

Where do you get this error? Within a client application? If you are using .Net have a look to the inner exception(s).

Greets

Flo

Thanks Bob! 🙂

Mohit (3/31/2009)

---

As Ramesh suggested the GUI interface will not show you network drives or network servers. But you can enter in any path the SQL Service account has access.

You...

Hi

You may have a look for server triggers. There you can specify a LOGON trigger which fires whenever a user connects to server.

So you can simply insert the logon information...

You can either use xp_cmdshell to read the information into a table:

execute xp_cmdshell 'dir C:\Temp\*.txt'

... after parsing the information from input you can use OPENROWSET to read the data.

Or use...

... or bcp utility.

Greets

Flo

jmtmwaniki (3/31/2009)

---

hi guys

i have tried to convert my databases from 2000 server to sql 2005 but i simply cannot update. when i make netries via this databses, seems thaey have...

It's usually a default configuration problem with the .net database provider. Execute the following line in your client application:

SET ARITHABORT ON

After that it should work.

Greets

Flo

Hi George

So what is the specific problem?

* Do you want to know how to check the size of a file?

* Do you want to know how to get the content...

Hi

I don't know about this ODBC driver. Seems to be a custom ODBC driver developed by any third party company.

We have another solution for this and it works just fine:

We...

As previously stated don't mix...

Hi

Sure you can split your database into several year-based databases but it might become difficult to handle data depending on their referencial integrity. I don't know your database but what...

Hi

I don't know if this helps but maybe it is a firewall problem. See the following link:

http://social.technet.microsoft.com/Forums/en-US/sqlexpress/thread/7012f6b4-69eb-432a-89b4-33961fa28920/

Good luck

Flo

Hi Leland

First please surround your error in VB with a try-catch block and copy this to the catch:

' ...

...