Viewing 15 posts - 166 through 180 (of 1,109 total)
Andy Carroll (7/8/2008)
I am trying to create a report that calculates and returns a week-on-week variance both as an integer and as a percentage.
My query...
July 8, 2008 at 1:28 am
alikhan.mayana (7/7/2008)
Dear friends
I want to know the import/export tables from enterprise in SQL Server 2005.
I know that,we can import/export database but i want to know,
about tabels ?
This last message together...
July 8, 2008 at 1:22 am
alikhan.mayana (7/7/2008)
Dear FriendsCan anybody tel me How to import/export tables in SQL Server 2005.
Have a look at the BCP utility http://msdn.microsoft.com/en-us/library/ms162802.aspx
But there are many different ways to export/import tables....
July 7, 2008 at 6:29 am
Since you are not requiring that all permission bits should be present when comparing, but only one permission bit is set, you could use:
SELECT MenuItem, URL
FROM ...
July 7, 2008 at 6:28 am
Au4848 (7/3/2008)
Andras the statment fails at 'GRANT ALL' which is deprecated in 2005 so I'm looking what can be used in place ALL
It is deprecated, but it still seems...
July 3, 2008 at 9:13 am
karthikeyan (7/3/2008)
is it a group ? do we need to pay for this group ? Can you explain me the purpose of PASS ?
Have a look at http://www.sqlpass.org/
Regards,
Andras
July 3, 2008 at 8:21 am
Au4848 (7/3/2008)
Below statement works fine in 2000 what is equivalent in 2005?
SET Grant = 'GRANT ALL PRIVILEGES ON /* ' + @object_type + ' */ ' + @owner_name...
July 3, 2008 at 8:20 am
sreerekhavs (7/2/2008)
The system may have, say hundred of surveys and related data within it.
Our...
July 3, 2008 at 1:38 am
sreerekhavs (7/3/2008)
The system may have, say hundred of surveys and related data within it.
Our...
July 3, 2008 at 1:37 am
sudhakara (7/2/2008)
Sql server data base generating session id in negative value like -1,-2 .could you explain ?
Orphaned transactions get a session id of -2. Most common reason is DTC....
July 3, 2008 at 1:32 am
First a question, do you have an index for the day column? If you do, then my suggestion would be to go with the direct delete.
Also, is the delete done...
July 3, 2008 at 1:21 am
Imke Cronje (7/2/2008)
Thanks..i already know that....i have always done it manually...i ran the script below and it basically solved the problem:sp_change_users_login
If you are familiar with the UI already, you...
July 2, 2008 at 8:17 am
Imke Cronje (7/2/2008)
July 2, 2008 at 7:00 am
Imke Cronje (7/2/2008)
Thanks...just one problem....The script below doesn't work:EXEC sp_addrolemember N'db_owner', N'TestUser'
I will keep looking.
Could you tell me how it does not work? I.e. is there an error message? If...
July 2, 2008 at 6:31 am
You can, on 2005 try something along the lines of:
USE particularDatabase
GO
CREATE USER TestUser FOR LOGIN [TestUser]
GO
EXEC sp_addrolemember N'db_owner', N'TestUser'
GO
Regards,
Andras
July 2, 2008 at 2:48 am
Viewing 15 posts - 166 through 180 (of 1,109 total)