mlwiller2 (4/14/2014)

---

4Gb memory total on the sever. I have several databases over 20Gb that I can see SQL can't hold in RAM since the page life expediency time drops to...

mlwiller2 (4/14/2014)

---

I'm attempting to enable AWE on SQL Server 2005 SP2 Standard but have read there may/may not be other items to enable first depending on the version.

I know...

At what stage of configuring mirroring were you getting this error ..

--

SQLBuddy

Looks like you are using replication on 2000 server. Are you going to move it to the new server or re-setup replication on SQL 2005 server ?

BTW, how did you...

What errors are you getting ..

--

SQLBuddy

balasach82 (4/11/2014)

---

Windows 2008 cluster and windows 2008 r2 cluster

SQL 2008

For the above configuration, is there a way or query to find if the Cluster is active/active or active/passive or active/active/passive...

D-SQL (4/11/2014)

---

Trying to create an audit that goes to the application log. With a certain criteria, select, update, delete etc.. where like 'example'-- some criteria

is there any reference out there...

First try running the job using and see if it works then we can schedule it as a job ..

USE msdb ;

GO

EXEC dbo.sp_start_job N'Job_Name' ;

GO

--

SQLBuddy

Do you see any blocking\memory issues on the server ?

--

SQLBuddy

rajeshjaiswalraj (4/9/2014)

---

JUST I HAVE ONE DOUBT, IF I WILL NOT CREATE ANY CONFIG FILE SO I THINK NO USE OF MANUFAST FILE. WITH OUT CONFIG FILE ITS LIKE creating job...

Check if you are experiencing any memory problems and errors ..

--

SQLBuddy

Why do you want to do that using SSIS ? When you say backup Procs and Functions, what do you mean exactly ?

--

SQLBuddy

Jake Shelton (4/9/2014)

---

Hi all,

Is this feasible via the SSIS Transfer Logins task?? I've read a lot of articles talking about doing this scriptually instead, now I'd far rather have...

What's the "max worker threads" option for your SQL Server ? And is your SQL Server 32 bit or 64 bit ?

--

SQLBuddy

sourav_1002001 (4/9/2014)

---

I got an issue occured with my prod systems. I tried to open the properties of a database which gives error

"Cannot show requested dialog.

Additional information:

Cannot show...