thanks to reminer our friend it is a very old post 🙂

Thanks for your reply folk.

We are building a new server in order to stress test it. What is happening is that even having the available MPA memory on server, SQL...

Hi Folk,

Thanks for posting, I am passing thru this same issue and would like to know about the LInked Server change, did it affect your application behavior at any point?

I...

Hi Folks,

I got this same error this morning and could solve it by removing the certificates that were having the same name as my server. That solved my problem.

Maybe,...

DBCC LOGINFO shows the extends not empty into your log file. Shrink commands will only work when you have NO entry on the log file extends marked as 2...

Hi,

Just a matter of complementing our friend's answer:

How many disk do you have available to spread your files?

Why do you want to split your table? [Is it for increasing...

There is no sense the query you asked for, but it is possible to retrieve the info you need, just

build your query like the below one:

SELECT OrderFormNo

,ClientName

,OrderDate

,Product

,sum(Value)as Total

,InvoiceQuantity

,PendingQuantity

FROM AOM_Tbl_PendingOrders...

You are right Gilamonster. It depends on environment. But as you can see, if it was really important to their corporation they should hire a skilled DBA and not a...

To flush DNS Cache you use:

On CMD:

ipconfig /flushdns

Check the following points:

TCP/IP PORT

SQL Browser gotta be running

If you use an Account set to Admin group

Check SQL service SPN Registration

Issues like yours probably comes from some missing configuration;

Regards,

Hi Folk,

I hope, at first, this select helps you:

SELECT *

FROM INFORMATION_SCHEMA.ROUTINES

WHERE ROUTINE_DEFINITION LIKE '%SELECT%'

...

Flush DNS Cache and then try to access without doing anything else. Sometimes for dual homed networks

SQL gets timeout. The problem can be resolved by flushing DNS cache.

Regards.

Change the field type on Access table.

If you have both fields set to date type, try to use cast conversion while sending the info to

the fields.

For further help you can...

I know it's been a long time to answer this question, but for those who may need:

For regular backups you can use a maintenance plan with the following schedule:

Take...

I'm getting this same issue, but, this time due to my 00010008.ci file is corrupt;

Is is a case to reinstall Full Text Search?

:w00t:

Thanks in Advance!!