Mischa E.J. Hoogendoorn (11/12/2008)

---

Hi,

I am working with sql-server 2005 since a few weeks, (before it was sql2000), and there is one advantage I'd like to use, and that is the...

steveb (11/12/2008)

---

try this code to get the file paths for each db on a server.

DROP TABLE #DBFiles

CREATE TABLE #DBFiles

(

[DBName] [nvarchar](100),

...

if you will restore a backup, you will loose the changes after that backup of which restore you will take

IS there any use of Order By clause here

not in another table. just on the...

GilaMonster (11/12/2008)

---

krayknot (11/12/2008)

---

yes

store the pricing in xml and at the tiime of requirement, call the xml data in table variable (if the size is upto medium) and use temp table...

yes

store the pricing in...

Anu (11/12/2008)

---

hello.. see i just only wants the earlier code , from the sql server database , there is no demand for that must from log files !

any way...

sairams (11/11/2008)

---

Hi,

My problem is that i have a table which stores pricing information. I would like to secure the information stored in this table.

1. How will i avoid unnecessary...

Anu (11/11/2008)

---

Hi Sql Server's,

Here the scenario like this , i am using a stored proc that contains some functional business logic ,here i didn't took the backup script and start...

Uniqueidentifier is a string constant in the form xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx, in which each x is a hexadecimal digit in the range 0-9 or a-f. For example,...

rd (11/7/2008)

---

Hi there,

I like to keep several versions of a record in a table. To accomplish that I use the following SQL statement

BEGIN

IF object_id('tempdb..#T') IS NOT NULL

DROP TABLE #T

SELECT *...

tymberwyld (11/10/2008)

---

Basically what's going on here is that someone is looking at some wireframes of the UI and that's getting translated directly into a database design. If they want...

iqtedar (11/10/2008)

---

i was told to generate performance dashboard reports on two different databases. I never used performance dahsboards before. I request sql gurus here to help me with finding the...

Kim Talley (11/10/2008)

---

We do not allow dynamic sql on our servers. All SQL is done through stored procedures. The problem I have now is a stored procedure that needs to...