sql_Reporter (11/18/2008)

---

Hi i'd like to create a new folder in TSQL the folder name should look like WK##

where ## is the week number.

The week number will change each week....

Leo Leong (11/18/2008)

---

thanks for reply. 🙂

I found this in my event viewer:

-- ========================================================

Event Type:Error

Event Source:ClusDisk

Event Category:None

Event ID:1209

Date:11/18/2008

Time:12:46:08 AM

User:N/A

Computer:ServerName_of_PassiveNode

Description:

Cluster service is requesting a bus reset for device \Device\ClusDisk0.

For more information, see...

In the graphical execution plan you can find many options, for example, based data getting arrow marks shows thin line to thick lines. For more information see SQL BOL.

due to network problem, if SQL 2000 is exists in another location.

Very helpful script, used for many DBA's.

mr (11/17/2008)

---

Hello all,

New to SQL and having trouble with using MAX in a SELECT statement which is pulling info from a one many relationship.

I need some help with the best...

nairsanthu1977 (11/18/2008)

---

That's the problem..

We cant define the table straucture like that..It is depended on the parameter we pass.Number of fields and it's data types will vary as per the parameter...

First create temp. table and then use the following way:

insert into #temptable

exec sp_name;

🙂

SQL 2005 and above version use DDL Triggers, may help to you.

SQL 2000 and below version, use sp_who2 or sp_who3

for sp_who3 Links:

http://vyaskn.tripod.com/sp_who3.htm

http://www.sqlservercentral.com/scripts/Miscellaneous/31109/

http://www.eggheadcafe.com/software/aspnet/28578981/spwho3.aspx

What is your exact requirement ?

venki (11/13/2008)

---

Hi,

How can I get the key columns for a table i.e.

How can I get the primary key and foriegn keys for a table?

Please respond as soon as possible, its...

kokila (11/11/2008)

---

Dear All

In my database sever , there are mini dump files(SQL*.mdmp) created under log folder. Some log file and txt also which explains the information about the execption.

Can...

nikhil.verma (11/11/2008)

---

Hi All

When i am trying to start my sql server services ( sql server 2005) , it is throwing error : " FCB::Open: Operating system error 5(Access is denied.)...

bhuvnesh.dogra (11/11/2008)

---

hi

declare @lstr varchar(200)

declare @word varchar(20)

set @lstr = 'select top 1 name from sysobjects'

set @word = exec(@lstr)

select @word

i want ot store result comes from dynamic query...

SqlUser (11/11/2008)

---

Reqno status remarks

1 Ok ...