|
my database is having huge data and log files.
i want to know is if i shrink both data and log file then is there any data loss or harm to database?
can i shrink the master, tempdb database..??
Thank you
jayesh
|
|
|
|
|
Jes Talsaniya wrote: shrink both data and log file then is there any data loss or harm to database?
No and No
Jes Talsaniya wrote: can i shrink the master, tempdb database..??
Don't think so, and yes
Bob
Ashfield Consultants Ltd
|
|
|
|
|
This could be a very silly question, but here goes:
Our server is going to be down all weekend because of certain reasons.
Is there a way to move a sql server database onto a local machine?
thanks
The answers posted by me are suggestions only and cannot be used in anyway against me.
|
|
|
|
|
Detach/Attach. That'll be the least of your problems however. The real part is to migrate your applications/users to point to the local server until the main one is up.
|
|
|
|
|
As the previous post
Detach database
Copy DB files to your local machine
Atach those files
And change the connectionstring to point to the sqlserver instance in your local machine. I hope you are using connectionstrings from a web.config file (for web app) or saved the connectionstrings as a resource (for win app), Otherwise...too bad
Alexei Rodriguez
|
|
|
|
|
hi All,
how can i exclude the month of Auguest in sql server 2000?
this is what i did:
date < '2008-08-01' and date > '2008-08-31'
thanks all
|
|
|
|
|
Should be fine.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Thanks Bob, i worked out myslef, it should use or instead of and like this:
date < '2008-08-01' or date > '2008-08-31'
but still thanks
Andie
|
|
|
|
|
Sorry, misread. I thought your post already had OR , not AND
Bob
Ashfield Consultants Ltd
|
|
|
|
|
or
<br />
date <= '2008-08-01' and date >= '2008-08-31'
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.
|
|
|
|
|
Thanks i worked out myslef, it should use or instead of and like this:
date < '2008-08-01' or date > '2008-08-31'
but still thanks
Andie
|
|
|
|
|
listen, use this way instead
use function month()
declare @mydate smalldatetime
set @mydate = '1-6-2005'
select month(@mymonth)
if you run that you get 1
So, code like this:
if month(mydate) <> 8
begin
...
end
easyer
nelsonpaixao@yahoo.com.br
trying to help & get help
|
|
|
|
|
I am developing a software with SQL 2005 Express backend and i want to know how can i protect my databse from being viewed or modified by any DBMS?
|
|
|
|
|
Authorisation and authentication
Unless the app/dbms has the right credentials access is denied.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
|
By default, you can't do anything in the database unless you have the permissions to do so.
May be you need to get some introductory knowledge on SQL Server, in which case, get a book.
|
|
|
|
|
thanks for your reply.
any web resources you recommend?
|
|
|
|
|
isn't user-password good enough?!
Intelligence is almost useless for those who have nothing else!
Email: caiokf@gmail.com
|
|
|
|
|
Hello Friends,
I have got a requirement in which I have an Excel Workbook (latest version) as my source and SQL Server table as my destination. The scenario is that I have similar column names in both - source and destination.
So, now what I have to achieve is, if I insert some value in my excel sheet, then it should get updated in the SQL Server destination table. I have to avoid using SSIS for this.
I am not even sure if there is anyway to do this. I am researching on it and I would appreciate your help if you can also let me know your ideas.
Thank you,
notes4we
|
|
|
|
|
I suggest you use VBA to move the data to SQL. Probably fired by a button on your form.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hello,
Thank you for you reply. But do you know anyother way rather than using VBA, as Visual Basic is not installed on my local machine and there are only few excel sheets where I have to set this sort of link. So, I want to know if there is some other way to achieve this.
Thank you,
notes4we
|
|
|
|
|
notes4we wrote: Visual Basic is not installed on my local machine
No, but VBA should be installed, its part of Excel.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Ok. Is there any way to check if VBA is installed? And if it is there, then how do I exactly use if to achieve my objective. Can you please provide a brief note about it, as I have not used it before, so......
|
|
|
|
|
notes4we wrote: Is there any way to check if VBA is installed?
VBA need not be installed separately - it is part of the MS Office suite, and has always been present, at least since MS Office 97, and also exists in the latest MS Office 2007 version.
notes4we wrote: And if it is there, then how do I exactly use if to achieve my objective.
Search here[^]?
|
|
|
|
|
I found Visual Basic.
I am researching on the code now and how to use it exactly to achieve my objective.
I know google is the place where I can search for it and I am doing that, but still any thoughts from experienced people would be appreciated.
Thank you,
notes4we
|
|
|
|