Granting permissions on object level is done the same way regardless the authentication mode that the login is using. You just need to run grant statement. For example:

Grant...

SQL Reddy (11/15/2008)

---

The LOG file is about 20 GB,and it had 0 freespace in it.So I've done a LOG backup and the freespace in it is 19 GB now.I tried...

Maybe. If you took...

amitgupta.gec (11/11/2008)

---

USE master

Declare @RestoreFile varchar(255)

Set @RestoreFile='D:\Sql backup\Diff_'+ CONVERT(varchar, CURRENT_TIMESTAMP, 112) + '.BAK'

alter database dbname set offline with rollback immediate

RESTORE FILELISTONLY FROM DISK=@RestoreFile

RESTORE DATABASE dbname

FROM DISK=@RestoreFile

WITH

MOVE 'dbname _Data' TO 'D:\Sql...

SqlUser (11/11/2008)

---

Reqno status remarks

1 Ok ...

Most chances are that your data recovery model is set to full, but you don't have any log backup. I reccomend that you'll read in Books On Line about...

Kishore.P (11/10/2008)

---

try like the following:

CREATE PROCEDURE dbo.cte_test( @CustomerNumber Int)

AS

BEGIN

if (@CustomerNumber = 100 or @CustomerNumber > 0)

...

Smartdog (11/10/2008)

---

Thanks a lot for ur help, i thnk you got me right this time,

i just have one question, what is difference between row trigger and tabl trigger, and what...

iqtedar (11/9/2008)

---

i really dnt know how xyz is connecting...but her id is a windows ID and this the error msgs shes gtng when she is trying to login..Connection timeout...thank u...

Smartdog (11/9/2008)

---

sorry you got me wrong

um updating a record in a row in the table summary by adding the number of rows the been updated into the existing number

let for...

Notice that in the update statement I'm joining summery table to inserted views. This should make should update all the records in summery table, that were also updated in...

Smartdog (11/9/2008)

---

the table code:

/****** Object: Table [dbo].[Memo_Tasks] Script Date: 11/09/2008 14:49:47 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Memo_Tasks](

[task_no] [int] IDENTITY(1,1) NOT NULL,

[memo_code] [nvarchar](10) COLLATE Arabic_CI_AS NULL,

[memo_title]...

Smartdog (11/9/2008)

---

I'm new to triggers, i successfully made a new trigger that fires upon the change of a column value. On updating multiple rows in a new query using an...

iqtedar (11/8/2008)

---

Hello,

i have a question regarding assigning permission to the user..i did try searching the forum but didnt find anything..i know this place can...

I'm sorry but it isn't possible. Don't you have a backup to restore?

Adi