Friends,
I want the copy of Production DB into Reporting DB on daily basis. Considered that production DB is on Machine-A and Reporting DB is on Machine-B. Please give me your valuable suggestion.
Thanks,
JK
jvskarthick
Last Activity: Dec 14 '11, 07:24 PM
Joined: Nov 15 '06
Location: USA - Denver
-
Copy of Production DB into Reporting DB on daily basis.
-
The server exists on client side. we are doing the support to them. Trigger (Client DBA) can diable and do the modification whatever he want to correct? is there any other way we can? -
Replace the variable value with new one (in all SP's)
Hi,
I have a variable and it’s used in my all stored procedure. I want to replace the variable value with new one. Is there a way we can replace the variable with some other one in all the SP and recompile it using the Query.
Thanks,
JK -
DBA member updated the data. How to confirm that he did the update.
Hi,
The person who is responsible for the database (DBA member at client place) updated the particular data in table . How to confirm that he did the update and what time? User name? Machine name?.
we can create the trigger on all the tables but (DBA member at client place) can disable and update the data. (so this is not sufficient one)
we can create the Change Data Capture CDC on all the tables but it’s not... -
SQL Trim problem
Hi,
Check with the below given option.
DECLARE @STR VARCHAR(8)
SELECT @STR = '01105'
--SELECT ISNUMERIC(@STR)
SELECT CASE WHEN ISNUMERIC(@STR) = 1 THEN RIGHT(('0000000 0' + @STR), 8) ELSE RIGHT(('0000000 0' + @STR), 8) END
Thanks,
JKLeave a comment:
-
IN Statement "Determines whether a specified value matches any value in a sub query or a list". We can't use the IN with ('KW%'). If you are using % then you need to use LIKE operator only.
If you want to use the IN then give the full value inside the IN (‘Full Name stored in Table’), otherwise in your table you can add the column Region in existing table “CONTACT C” and bring the values directly from it....Leave a comment:
-
exec('select branchid from '+@tablename+' where Entrystatus=''N EW'' AND BranchName= '+@branchname')
Just change 'NEW' to ''NEW'' and try it...
Reg,
JKLeave a comment:
-
Without using function
create table #test (id INT identity(1,1), Password Varchar(10))
insert into #test (Password) values ('a')
insert into #test (Password) values ('b')
insert into #test (Password) values ('c')
insert into #test (Password) values ('d')
insert into #test (Password) values ('e')
insert into #test (Password) values ('f')
insert into #test (Password) values ('g')
...Leave a comment:
-
jvskarthick started a topic Single Trigger for "SELECT" execution happens irrespective of any table.in SQL ServerSingle Trigger for "SELECT" execution happens irrespective of any table.
Whenever the “SELECT” command execution happens irrespective of any table inside one particular database Log information into one Log table.
The Information required
1) User logged in
2) Machine details
3) Table Name
4)
In My DB there were more than 100 tables. I want to Wright single trigger like "DDL trigger" to know what are tables are got executed at which time, by which user and... -
Inserting Unicode data...
Wrong - I think you have created the Table with VARCHAR Data type, it won’t accept the Unicode data. Check the below example
Create table UnicodeData (Uni_Code varchar(100))
Insert into UnicodeData values (N'سي')
select * from UnicodeData
Output
------
??
Correct - created the Table with NVARCHAR Data type, it will accept the Unicode data....Leave a comment:
-
The condition what you checked is
if s2_sess_datetim e is not null and s2_individual_s ession = '1'
Note : Without declaring the variable not possible to check the condition directly, it's possible by using the conditional statements like IF EXISTS()
Please use the below given steps
Step - 1
-----------------------
Declare the variable like.
DECLARE
@s2_sess_dateti me...Leave a comment:
-
For Example:
1) Server Name as - SERVER1
2) DB Name - DB1
3) Backup Copy name - DB1.bak (taken the backup before deleting the table1)
4) Consider U have delited the table1 from DB1 database
Step 1:
Restore the copy of the DB in to the same server with Different DB name.
Exam)
Restore the DB1.bak with DB2 (database name)
Step 2:
USE DB1
GO
...Leave a comment:
-
CSS with Crystal reports
Hi
I am very new to crystal reports at present I am working with Crystal reports actually my requirement is, I have to create verity of reports more then 100 reports. After creating the reports if the client wants to change the Font size from 10 to 11 or one type of Font to another type of Font in all reports means, I have to open each and every report and need to do the changes instead of that I want to create the common style sheet (CSS)...
No activity results to display
Leave a comment: