|
Thanks Mr.David for your quick response. Thanks again for reminding me to use sql profiler. I will try today itself.
Be a good professional who shares programming secrets with others.
|
|
|
|
|
hi,
I am using sql server 2005 and i have to deploy my database into client side.
my database table having some very important data and
I want to restrict server administrator not to open my database or he can not make any direct changes in databse table.
Please let me know , is there any way to stop server adminstrator to make direct changes in database.
Is there any sql scripts to stop this.
thanks
Hari
|
|
|
|
|
As far as I know you cannot stop the SA account from accessing any database, thats the whole point of the sa.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
If you need to restrict windows administrators, you can disable BUILTIN/Administrators from logins. If it is something else you need, could you specify a bit more.
Mika
|
|
|
|
|
Hello people,
Is there any good link to study about LDAP server and its main usage and where it will be deployed ?
Many Thanks,
Sakthi
Nice things do nice works
|
|
|
|
|
hi all ,
i'm trying to import db from one db to other , here i'm getting only tables and views only .
in that db i'm having stored procedures also but im not getting stored procedures .
can any body explain me how to get the whole db .
Thanks ,
csn
|
|
|
|
|
Redgate[^] has excellent tools for working with databases.
|
|
|
|
|
For Procs you will have to generate script in old DB and then execute it in new db after imporying tables and views.
By the way whats exact nature of requirement that is forcing you to import DB?
Razov
If you think this answer helps you please rate it, it helps me. 
|
|
|
|
|
Hi, you have 2 choose option "copy objects and data between sql server databases" in export wizard. Then click Next, check all the options provided, then click Next, then Finish.
If this solution solves your problem, please rate this.
Be a good professional who shares programming secrets with others.
|
|
|
|
|
i want to install the sql 2000 database in other machine.
so how to create sql 2000 database setup?
|
|
|
|
|
|
Jeez, I take it you never heard of Google?
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
Well, first you must build a difference machine...
“If we are all in agreement on the decision - then I propose we postpone further discussion of this matter until our next meeting to give ourselves time to develop disagreement and perhaps gain some understanding of what the decision is all about.”-Alfred P. Sloan
|
|
|
|
|
Hi friends, i need to know how much space occupied by database with my data in sqlserver 2005.
to know this i did by right clicking on database and has seen it properties it showing nearly 2.4GB. But my database doesn;t contain that much data?
how can i know the exact size of my database?
G. Satish
|
|
|
|
|
sp_databases
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
Hi
I have an access file which contains forms,tables,queries,..
How could I know what table or query the forms are taking data from?
I am too late but i will never give up
|
|
|
|
|
In MS-Access,
1) Open a form
2) Switch into design view
3) In the upper left corner of the form you will find a small black square. Place your mouse on the square, right click and choose "Properties"
4) On the pop-up window, click on the "Data" tab and look at the "Record Source", this is where the form is getting its data. The data can be from a table, query or a query defined only for the current form.
Hope this helps.
David
|
|
|
|
|
hi there!!!!
i just wanna ask for suggestions.......for my project!!!
i haven't start it yet! i don't have any idea,"what topic that i can choose" please....help me!!!!!!!!!
i have knowledge about C/C++,Vb.6 and mySQL
|
|
|
|
|
What stops you to start your project?
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
Well, my latest project is to install a new bathroom if that helps.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
|
do a rent-a-movie software (did one before) or library software for exemple.
They are easy & good because you can built it has a stand-alone (no need to build network if you wish) 
Better you see samples from projects that came in ebooks.
Go to www.ebooks-space.com[^] download a ebook that cames with a project you like. 
nelsonpaixao@yahoo.com.br
trying to help & get help
|
|
|
|
|
Hi...can any1 assist me plz....im using sql 2005...i have multiple selects seperated by if statements like this:
IF @Monday = 0
SELECT [Day],[Date] FROM dbo.fnGetDatesforAday('2008/09/10', '2008/09/30','Monday')
IF @Tuesday = 1
SELECT [Day],[Date] FROM dbo.fnGetDatesforAday('2008/09/10', '2008/09/30','Tuesday')
is there a way to execute both selects as 1 query
living life on the flip side
|
|
|
|
|
SELECT
[Day],[Date]
FROM
dbo.fnGetDatesforAday('2008/09/10', '2008/09/30',(
SELECT
CASE @Monday
WHEN 0 THEN 'Monday'
WHEN 1 THEN 'Tuesday'
ELSE 'Other'
END
)
)It's a wild guess, I haven't executed it though.
|
|
|
|
|
Hi,
kinldy let me know that, how to remove spaces using query?
Example
--------
FullName
------------------
RIAZ - BASHIR ===>>> RIAZ-BASHIR
KASHIF - HAROON ===>>> KASHIF-HAROON
Thank you in advance
(Riaz)
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
