Hi,

This is the similar message to what I receive when using sp_configure. For example,

Use Master

Exec sp_configure 'allow updates', 1

RECONFIGURE WITH OVERRIDE

GO

My script does do Reconfigure, but this "error" informationsl...

Remi,

Did you remember our discussion with ram4tech at

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=198251#bm198292

Strange situation when retrieving data (only 6 records)

I understand there was a problem with locking or open transaction and he finally...

Hello,

I too use this sytax with source server SIDs to create a list of logins in the destination server like on a test server.

I usually do it with a script...

Andy,

This is a great advice about placeholders.

I also would like to mention Tempdb that may as well grow fast even with read-only reporting as I found out once.

Yelena

Hello,

This is a good article and a good advice. Now about roundtrips:

There are at least 2 network trips: From a Client to a Web Server and From the Web Server...

Hi,

We had a discussion on this some time ago.

It appears that if you create registrations with Read/Store User Independent property checked in EM then you can share registrations.

Or you can...

There is a workaround.

Please, check on the old server what was the owner, his/her/it name and sid by:

use myolddatabase

select name, sid from master.dbo.syslogins where sid =

(select sid from sysusers where...

Hi,

Listen to Brian, he is totally correct. More reasons it does not work.

What are you using by the way on the client? Named Pipes still may work if the name...

Hello Juanita,

Is there a reason why MS Acces has to go through SQL Server?

If no, then use File ->Get External Data ->Link Table in mS Access and use ODBC source...

I just want to add that in Server Network Utility of SQL Server on General tab in selected protocols if you click TCP/IP and click Properties there is a Hide...

Hello,

It is a name resolution issue. You say it is a new server. It may be one of the following:

- DNS server that resolves the name into IP address does...

Here is the reference:

http://support.microsoft.com/default.aspx?scid=kb;en-us;305977

INF: Frequently Asked Questions - SQL Server 2000 - Table Variables

Q4: Are table variables memory-only structures that are assured better performance as compared to...

I like SMTP from VB script

I also tried Database Mail of SQL Server 2005 CTP evaluatiuon copy. It is not difficult to set up and works fine. See Books Online...

Hello JW,

You say " I was optimizing some tables (a function in Navision..)..Usually this triggers a rollback "

We don't know how this function is coded by Microsoft programmers. Some transactions may...

In addition take a look at Microsoft White Paper

Building Secure ASP.NET Applications, downloadable at

http://www.microsoft.com/downloads/details.aspx?FamilyID=055ff772-97fe-41b8-a58c-bf9c6593f25e&DisplayLang=en

file name:secnet.exe, unzip it

Chapter 12 under