Try executing

Xp_logininfo 'NT AUTHORITY\SYSTEM'

In the type you will come to know whether it is group or single user account.

Nag

Jeff Moden (6/2/2010)

---

WayneS (6/1/2010)

---

How many times have you been told that...

Can you be bit clear with what format you need, which will help people to answer.

Nag

Try this query

INSERT INTO #Space_Table (RowID, Server_Name, DBName, Flag, FileID, File_Group, Total_Space, UsedSpace, FreeSpace, FreePct, Name, [FileName], Report_Date)

EXEC GetFileSpaceStats 1

Nag

Yes you can by adding proper indexes, but again the behavior of index and what your query is doing and look into the execution plans then you can decided on...

your welcome Randy, the article mentioned in my last reply will help you to kick start.

In simple words seek means in a library you know the location of book which...

It is basically number of seeks and scans performed on the particular index.

If you don't know the difference between index seeks and scans? please read this article. this is...

I think it is because of difference in time stamps, please host some sample data as per Ron's response or use convert function in your group by.

Nag

I 100% agree with you Jeff, my solution was for limited number of records not for huge data.

Nag

In the following link, install SQLServer2005_BC.msi hope that will help you.

http://www.microsoft.com/downloads/details.aspx?FamilyID=c6c3e9ef-ba29-4a43-8d69-a2bed18fe73c&displaylang=en#QuickInfoContainer

Nag.

Try using For each loop container that should help you.

Nag

changbluesky (5/31/2010)

---

please take a look at the below SQL CODE

---

create table mytable

(

potype varchar(10)

)

insert into mytable values

('AA'),

('BB'),

('CC')

declare @potypestring varchar(50)=''

declare @potype varchar(10)

declare mytype cursor local for

select potype from mytable

open mytype

fetch next from...

What error you're getting for PK column?

Nag

TRUNCATE TABLE permissions is default to the members of the sysadmin fixed server role, and the db_owner and db_ddladmin fixed database roles. I think you should be able to do.....

Lucky9 (5/19/2010)

---

I have to keep track of change for one of the column in one of the tables..

If the column gets updated then i need to Insert the updated column...