Hi david,

Sorry, my connectionstring for the name server, instance and database is not like above, I write like that because I don't want another people know it.

FYI, for (LOCAL) i...

David McKinney (4/9/2010)

---

WAIT A MINUTE! ARE YOU SURE YOU WANT TO DROP YOUR INDEX?

Not entirely sure what's going on, but it looks like your going to drop (have dropped) the...

Hi RonKin,

To make it sure, you can read Summary.txt from C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log

Regards,

Eko Indriyawan

messagetosiva (4/9/2010)

---

I have been working with Access 2003 till now but want to move into SQL Server 2008.

Do you have any books that will help me in this transition...

David McKinney (4/9/2010)

---

Sounds to me like this may be a "double hop" issue, where authentication is not working.

In short, if you're going from A to B to C (Delphi to...

Thanks for your replies,

FYI, When I execute the stored procedure with SSMS, there are no error message and still working properly.

But, when I Execute the stored procedure with Delphi through...

Have you tried to combine Synonyms and views, maybe with these technique make the query more efficient.

Regards,

Eko Indriyawan

Let your read this article :

http://support.microsoft.com/kb/272358

Regards,

Eko Indriyawan

Thanks for your suggestion.

Regards,

Eko Indriyawan

Thanks for your replies,

Actually everything of my stored procedure and the configuration is fine, but I have to execute the stored procedure 3-5 times first and then working properly.

Do I...

Thank you very much for your suggestions.

I use InstallAware to build installer, InstallAware can config the service only the service that we've created.

It can not config the service that already...

You're right.

I need this command to create installer of my product.

1. Installer install MS SQL Server

2. Installer start the service when the service of MS SQL Server not start

3. Installer...

Hi Jeffrey Williams,

Thanks for your replies.

Maybe my question is so strange.

But I can do it based on command prompt using XP_CMDSHELL

ex:

XP_CMDSHELL 'SC CONFIG MSDTC START= AUTO'

GO

XP_CMDSHELL 'SC START MSDTC'

GO

for more...

Jeff Moden (1/21/2010)

---

Yes...

The first "1" controls how many "levels" to go down from the directory listed in quotes with the directory listed in the quotes being "Level 1". In...

Hello Jeff Moden,

Thank you very much. Your...