my company management has decided to have a backup to the nas share folder so if users/DBAs are trying to take a backup to another location (i.e to thier local drive) they would not be able to do that, how can I achieve this task. I was thinking of using policy based management but not sure how can I apply to many servers. I would appriciate your thoughts on this.
Thanks... Dev
Deven Oza
Last Activity: Oct 15 '13, 03:27 PM
Joined: Oct 15 '06
Location:
-
must have backup to the specific location only
-
Thanks Baseem, I have created a simple button rather than using this java script and its working but I will try the way you have suggested. Thanks for your help! -
How can call function using button?
The following lines of code calling TerminateManage r.aspx page when I click on button(please see the code), instead of calling .aspx page I want to call function Check(), how can I do that?
This following code is written in aspx.cs page and the function Check() I like to call is also in the same page.
...Code:this.PlaceHolderTerminateManagerButton.Controls.Ad d(new LiteralControl("<input type='Button' value='Terminate Manager' -
How can I call function using button?
The following lines of code calling TerminateManage r.aspx page when I click on button(please see the code), instead of calling .aspx page I want to call function Check(), how can I do that?
This following code is written in aspx.cs page and the function Check() I like to call is also in the same page.
Please help! Thanks!
this.PlaceHolde rTerminateManag erButton.Contro ls.Add(new LiteralControl( "<input... -
Distinct Count - SSAS
Hi All,
I am changing measures property "sum" to "distinct count" but when I am looking at the browser to see the data, its not changing at all, the data value is same as I was getting before. what should be done to make it effect? I have already processed the cubes but still getting same result.
SQL server 2005 analysis server
Thanks in advance!
Thanks,
Deve... -
SSAS 2005 help
Hello All,
I am working on sql server analysis project and I am having an error and I tried lot to figure out the problem but anable to do it.
Here is the my work situation.....
I did right click on the cube and I am putting my measure 'A' in browser area to browse the data but that measure 'A' is not giving me any data for any dimension. I am putting dimensions to rows and columns but not able to see data and... -
ok, my SSIS package (sql server 2005) transfers data in excel 1 and in excel 2 and I want to add column either in excel 1 or in excel 2 like following,
excel 1
A1 B1
excel 2
C1 D1
what want is
either excel 1
A1 B1 C1 D1
or excel 2
A1 B1 C1 D1
Thank you,
DevenLeave a comment:
-
How to copy column(s) from one excel sheet to another using sql server.
Hi,
Does anyone have an idea that how to copy column(s) from one excel sheet to another sheet using sql server.
Thanks for your help in advance.
-Deven -
SSIS Union all difficulty
Hi All,
I have created SSIS package and I wanted to transfter data from two different tables to excel sheet and when I used union all function its return me error says cannot convert into unicode, I already used Data Conversion Transformation but didn't help, what should I do please advice. Please note: both tables have different column names.
Thanks,
DB -
Duplicate records
I have a table with duplicate records and I want to delete one set of records from this table. is there any function which I can use in remove this dups from table.
thanks,
Deven -
Oh my God!!!! It's working now, yes it is working... Thanks a lot!!!!
Happy Coding :-)...Leave a comment:
-
Stored Procedure... pls help
Create PROCEDURE NextGen_Convert Date_Deven AS
declare @DLSStart smalldatetime
set @DLSStart = (select dbo.fn_GetDayli ghtSavingsTimeS tart(convert(va rchar,datepart( year,getdate()) )))
/* please Note this funcution (fn_GetDaylight SavingsTimeStar t) returns values is 2008-03-09 02:00:00 */
update NexGen_New_Loss es_Deven
set F37_CLAIM_ENTER ED_S_DT_conv =
CASE
WHEN XM_REPORTING_MC O_NM... -
Hey my code is working now by doing simply deleting cursor, now I am using simple two update statements and it is working fine, anyway thank you very much you looked at it.
ALTER PROCEDURE aim_sp_Convertd ate_Deven2 AS
declare @DLSStart smalldatetime
, @DLSEnd smalldatetime
, @Date smalldatetime
--, @DLSActive tinyint
set @DLSStart = (select dbo.fn_GetDayli ghtSavingsTimeS tart(convert(va rchar,datepart( year,getdate()) )))...Leave a comment:
-
Thank you for looking at my code.... that's true that I made some changes after posting it here.. Here I am posting my updated code... the problem is that the only ELSE part is working no matter what date I pass...
-------------------------------------------------------------------------
CREATE PROCEDURE aim_sp_Convertd ate_Deven3 AS
DECLARE @DLSStart smalldatetime
, @DLSEnd smalldatetime
, @Date smalldatetime...Leave a comment:
-
error in sp code....
hi,
Please help me in following code of stored procedure….
My table and data: select * from nextGen_deven
--------------------------------------------------------------------------
Name1 enterdate convertedDate
Deven 2008-01-05 00:00:00.000 NULL
Deven1 2008-02-05 10:10:10.000 NULL
Deven2 2008-03-05 10:20:10.000 NULL
Deven3 2008-04-05 22:22:00.000 NULL
... -
need help!!
Hello Friends,
Please help me in following code of stored procedure…. I think the problem is in between of BEGIN and END.
My table and data: select * from nextGen_deven
--------------------------------------------------------------------------
Name1 enterdate convertedDate
Deven 2008-01-05 00:00:00.000 NULL
Deven1 2008-02-05... -
SELECT query on joined tables
Here are two sample tables of information which are used by a high school to keep track of the grades for its students. One table contains the names and addresses of the students, together with a student ID number. The second table contains the class name and class ID number, together with the student ID number and the grade for that student for that class. If the student did not take the class, the class grade is left empty. To list the grades for... -
Please solve this query for me.
Hi every one
can anybody solve this problem for me.
What initial values of a and c are required such that the final values of a and b are:
a = 32
b = 4
…
int a,b,c
a = ?
b = 0
c = ?
for( b=0; a<12; b++ )
{
a = (a+a) * c;
}
…
Thank you
Deven -
Thank you,
Deven Oza...Leave a comment:
-
Need Help
Hi every one
can anybody solve this problem for me.
What initial values of a and c are required such that the final values of a and b are:
a = 32
b = 4
…
int a,b,c
a = ?
b = 0
c = ?
for( b=0; a<12; b++ )
{
a = (a+a) * c;
}
…
Thank you
Deven
No activity results to display
Leave a comment: