Outside of SQL, you can use a free app called Textpad. Inside of SQL you can use sp_readerrorlog ... then you could dump it into a temp table with an...

Any assistance would be much appreciated.

Thanks

Any assistance would be much appreciated.

Thanks

Thanks, but not...

GSquared (7/2/2008)

---

Why would you have to make it a proc to use a function like FileProperty? Just set the right columns to be the input parameters, and use Cross...

GSquared (7/1/2008)

---

You can use CASE in calculated columns (which is what this is). The problem isn't the first "AS", it's the second one. You can't alias a computed...

I'm curious ... why are you against temp tables? If you're configured properly they will perform just as good as a real table and are (in my mind) much better...

Pam Ozer (6/27/2008)

---

Yes. I am trying to back up to a different sql server. I have a domain account running services and that same domain account has permissions...

Data:

-- ***************************************************************************

-- nvarchar(4000) = dbo.fn_SQLServerDataDir()

-- ***************************************************************************

IF OBJECT_ID('SQLServerDataDir_fn','FN') IS NOT NULL

DROP FUNCTION SQLServerDataDir_fn

GO

create function dbo.SQLServerDataDir_fn()

returns nvarchar(4000)

as

begin

declare @rc int,

@dir nvarchar(4000)

exec @rc = master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE',N'Software\Microsoft\MSSQLServer\MSSQLServer',N'DefaultData', @dir output, 'no_output'

if (@dir is null)

begin

exec @rc...

Does the account running SQL have access to this folder?

lior (6/27/2008)

---

I see.

I started to look at my indexes and stats, and I admit I never really took the time to do it before. The stats haven't been updated in...

You need to see the execution plan (it's right next to the stop sign in SSMS) to determine if you're seeking or scanning indexes or tables and then looking at...

If you...

This can be done, but is HIGHLY not recommended ... I've done it myself in the past and ran into lots of issues.

In order to attach a remote database file,...

Have you analyzed the execution plan of this query? Are your indexes healthy? Are your statistics up to date?