Have you (double) checked the given path exists locally on the SQL Server? And does the SQL Server service account has...

Excellent article!

You had a lot of issues, but managed to fix them working together with the windows and network admins. Unfortunate I'm working with external service providers who are always...

Just a sidenote: if the restore command is executed with the option "WITH NORECOVERY" the database stays in the restoring state. You won't find an corresponding active RESTORE command, because...

You can install multiple versions on the same computer. Best practice is to first install the older version (you say you have already SQL Compact) and then continue with the...

ramana3327 (10/6/2014)

---

Little confuse about the profiler timings.

Correct me if I am wrong

When we selecting trace from Tools the time filter is in milliseconds but when we are monitoring from the...

A deadlock involves two actions that both need an lock (mostly on a row or page) but the resource is already locked by the other action. Most of the times...

Make sure you have set the correct permissions on the folder to the SQL Service account.

With your new requirements we don't have enough information to provide a solution. You can't just only query on the existance of the parameter values anymore.

You need to query on...

Default it will read all sequential files, but you can add the desired number of files as an extra parameter,. See sys.fn_trace_gettable (Transact-SQL) for a complete explanation of this function.

GilaMonster (10/6/2014)

---

HanShi (10/6/2014)

---

If the second server doesn't have access to the D drive of the first server you first need to copy the physical file to an accessible location. Next...

If the second server doesn't have access to the D drive of the first server you first need to copy the physical file to an accessible location. Next you can...

You made some mistakes in the sequence of commands (specific tyhe "SELECT 1"). Below code should do it:

CREATE PROCEDURE [dbo].[Sproc__Save_Teacher_Details]

-- Add the parameters for the stored procedure here

@FacilitiDetailID...

Formatting of display values is best done inside the application. Application programming languages are far better in manipulating strings.

If you realy want to do it in SQL you need to...

Last weekend attended the preconference and SQL Saturday in Vianen/Utrecht (The Netherlands). Unfortunate Learte JR couldn't make it so I missed the Powershell pre-con. So I went to Denny Cherry...

When upgrading a database to a newer version, don't forget to execute the following steps:

- change compatibility level to the current level (if no old syntax is used)

- change verification...