Viewing 15 posts - 31 through 45 (of 82 total)
Try executing
Xp_logininfo 'NT AUTHORITY\SYSTEM'
In the type you will come to know whether it is group or single user account.
Nag
Nag
------------------------------------------------
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
June 2, 2010 at 2:40 am
Jeff Moden (6/2/2010)
WayneS (6/1/2010)
Nagesh S-432384 (5/31/2010)
I 100% agree with you Jeff, my solution was for limited number of records not for huge data.Nag
How many times have you been told that...
Nag
------------------------------------------------
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
June 2, 2010 at 1:54 am
Can you be bit clear with what format you need, which will help people to answer.
Nag
Nag
------------------------------------------------
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
June 1, 2010 at 5:48 am
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
Nag
------------------------------------------------
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
June 1, 2010 at 5:45 am
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...
Nag
------------------------------------------------
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
June 1, 2010 at 4:22 am
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...
Nag
------------------------------------------------
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
June 1, 2010 at 3:42 am
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...
Nag
------------------------------------------------
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
June 1, 2010 at 3:05 am
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
Nag
------------------------------------------------
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
June 1, 2010 at 12:39 am
I 100% agree with you Jeff, my solution was for limited number of records not for huge data.
Nag
Nag
------------------------------------------------
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
May 31, 2010 at 11:29 pm
In the following link, install SQLServer2005_BC.msi hope that will help you.
Nag.
Nag
------------------------------------------------
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
May 31, 2010 at 5:00 am
Try using For each loop container that should help you.
Nag
Nag
------------------------------------------------
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
May 31, 2010 at 4:39 am
changbluesky (5/31/2010)
---
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...
Nag
------------------------------------------------
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
May 31, 2010 at 3:44 am
What error you're getting for PK column?
Nag
Nag
------------------------------------------------
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
May 25, 2010 at 12:05 am
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.....
Nag
------------------------------------------------
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
May 21, 2010 at 12:54 am
Lucky9 (5/19/2010)
If the column gets updated then i need to Insert the updated column...
Nag
------------------------------------------------
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
May 20, 2010 at 6:21 am
Viewing 15 posts - 31 through 45 (of 82 total)