Hi RP

Try to check if there are any changes that have been made on the server and any new process has...

Hi

If you are using a VMWare, then you can create a template mahcine and then clone from that machine, all you have to do is to...

rbarryyoung : this is a greek text that we receive from the greek user, once we receive the text then we insert them into a table with other information...

Thanks mate, this will store some other characters, if i select from the database then i get some other characters instead of actual greek characters, is it possible to insert...

Hi Gial

Sorry about the delay,please find the code attached

CREATE PROCEDURE [dbo].[GetMatch] (@TypeID INT = 0, @Priority INT =...

Hi Guys

You can use database snapshot on Developer edition as well 🙂

Thanks Gial

i tried on test server with login that are used by application, it dint work, then i...

Hi Tayal

What's the SAN you have got with you, for start you can start with hooking up SAN with ESX host( as...

Thaks Hill, i have one instance per server, and i have set a max memory as well, its releatively small machine, its having 6 GB RAM, out of which 5...

Hi Mike

This error seems that the excel file is been used by some other process apart from ur import task, is this...

Thanks Gial

I tought of this as well, since this is been updated or deleted by...

HI Lenny

Its a java exe file that clears the cache, i saw permission, i have done this before, i have done this on command...

yeap i know, thats the whole point of doing this trigger 🙂

Create TRIGGER BlTri

on Table1

AFTER INSERT, UPDATE, DELETE

AS

Declare @Name varchar(15)

Declare @Age varchar(15)

Declare @sql varchar(255)

select @Name=Name,@Age=age from deleted

union

select @Name=Name,@Age=age from inserted

set @sql ='c:\Bond\Bondcli "tablePKDAO{phone=''' + rtrim(@Name) + ''', age='...

Thanks Paul,

This seems to be a nice Idea, i tried to run the same SQL frequently so it deletes...