Here the local sql server's object id will need to apply. but if...

S Hodkinson (1/20/2009)

---

I feel that this may be a stupid question but is there anyway a 'sa' password can be retrieved when the developer has lost it (the password)?

In a...

abhishek.sahoo (1/20/2009)

---

We have table reside in a linked server having more than 15 million data. Please provide me a T -SQL which can retrieve the number of rows as fast...

declare @random varchar(50)

set @random = newid()

print (@random)

select substring(@random,1, 16)

mgalgey (1/20/2009)

---

I need a way to auto create stored procedures to insert, update and select. I also need to be able to extract custom code from the previous version for...

MSDN IS THE BEST in this regard

mithun.gite (12/30/2008)

---

Dear All,

I have one issue with my stored proc,

My sp is having dynamic sql like at the end of the sp i execute

exec(@sql)

but size of my @sql is more...

nazaninahmady_sh (12/29/2008)

---

hello,

i have a table with tis design:

ID int

Title ...

Paresh Prajapati (12/29/2008)

---

I have transfer database backup file on network storage device by FTP.

When i upload backup file on FTP it reduce size of backup file.

why it happen?

Bec when i...

alokkumar_srivastava (12/19/2008)

---

Hi All,

I am working on Sql Server 2005 Reporting Services (Cubes as a data source ). There is a requirement to get the employee details who are going to...

prakashdotc (12/21/2008)

---

Hi All,

I already have a query which retrieve data based on various dates, now i need is the Column header with those 'Date'.

Dynamic Dates as Column Header.

Is there any...

priyanka.scholar (12/14/2008)

---

Hi,

I have a SP whose ouput i need to use in another SP.

I wish to use the output of this SP in another SP.

However,I am aware of using a...

viji (12/14/2008)

---

Hi,

I'm querying on a tera byte storage data. so i want to know which will be faster the where condition or the inner joins for example

select sales, BP,...

bytezone (12/10/2008)

---

I am in a weird situation. I basically work for a state government . The job is secure, but not challenging enough for me to learn new technologies. My...

reubenfoo89 (12/8/2008)

---

Hi all,

i would want to be able to import data from an excel file into a MS access database.. Pls check my codes to see what is wrong.

[font="Verdana"]1. I've...