Archived Months
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
all groups > sql server new users > september 2006 > threads for september 29 - 30, 2006

Filter by week: 1 2 3 4 5

grant a user a temporary SA permission for a spesific action
Posted by Sam at 9/29/2006 7:41:32 PM
how can i grant a user a temporary SA permission for a spesific action (like alter a column in a table)? thanks ...more >>


raiserror
Posted by Sergey Karimov at 9/29/2006 7:01:02 PM
I have question about RAISERROR command. Look at the example above. first select shows one record in table, that means that transaction was committed. second select shows that transaction was not committed. My intention is raising exception similar to PK constraint violation. As you see from...more >>

File Pointing in SQL
Posted by kdawg99 at 9/29/2006 11:58:16 AM
I am trying to reference files in my SQL db which are stored on my database. I do not want to store the files in the actual database. I have a web interface where the user searches for the file finds the referenced file then tries to download it. But for some reason when they try to download t...more >>

Unexpected Activity
Posted by Joseph at 9/29/2006 5:37:02 AM
I am new to SQL 2000 Administration. My SQL Server has started indicating a lot more disk activity than it has done in the past. There are no jobs being run and it is degrading the performance of the system. How can I track the problem to the source? Thanks in advance....more >>



DevelopmentNow Blog