|
|
Hi
I need Script to backup selected database of SQL Server 2000. Script should have facility to add the database in the backup schedule in future.
Can any one help me out.
Regards
Vivek
|
|
|
|
|
To get you to the start, open Management Studio, create the backup and script it to a SQL Script.
You can also schedule the backup and then script the job which is created under the Sql Server Agent.
|
|
|
|
|
What is the datatype of the audio or video data to store in sql2005 database.
|
|
|
|
|
|
i m new candidate to learning vb.net. my que is database connectivity in vb .net using Access..?
|
|
|
|
|
Try connectionstrings.com
Search through the articles here and on Google, there are plenty of excellent samples around. Learn to do some research before dropping such an open question into a forum. When you run into a specific problem we will be more than happy to help.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
use oledb.
But i suspect that you did not buy a Book
try and get a Book that will guide you step by Step.
http://www.apress.com/book/view/143021614x[^]
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswam@its.co.za
|
|
|
|
|
i've a table contains name,cardid and the cardstatus.there are many cards for i customer,i want to check for each customer if he has a card with the cardstatus="bad" and if so need to return false.
can any one suggest me how to do this .
|
|
|
|
|
SELECT CASE ISNULL(COUNT(*),0) WHEN 0 THEN True ELSE False END FROM table WHERE Name=@name AND CardStatus='bad'
Or something like that?
|
|
|
|
|
Hello,
I have a Question related to SQL Server Connectivity .
I have my database on another PC and using the software created using VB.net 2005 on another PC, i.e. like Client Server.
I want to know whether connecting the SQL Server database directly from my application would give faster results or by creating a DSN connection on client machine and accessing the Data using Datasource would be faster.
Please anyone having idea about this.
Thank in Advance.
|
|
|
|
|
I think using .Net Framework's SqlConnection gives the best result as it is designed natively against Sql Server. It also provides more functionality than ODBC-based connections.
|
|
|
|
|
I'm using vb2005 connection to DB Ms Access.
If I have Columns in that DB it's typed Date/Time.Is it possible to rearrangement the Data(rows) in DB according the History.
it's mean if I have these Data
this is DB in Ms Access
A---B----C----H<br />
ZZ---FF---GG---2/12/2008<br />
QQ---UU---TT---1/12/2008<br />
RR---OO---PP---3/12/2008
To make this data like this
A---B----C----H<br />
QQ---UU---TT---1/12/2008<br />
ZZ---FF---GG---2/12/2008<br />
RR---OO---PP---3/12/2008
modified on Wednesday, December 31, 2008 6:59 AM
|
|
|
|
|
do a ORDER BY on the 'H' (date) column.
Any suggestions, ideas, or 'constructive criticism' are always welcome.
"There's no such thing as a stupid question, only stupid people." - Mr. Garrison
|
|
|
|
|
This will work when I select the data and showed in DataGridView example
but I want to rearrangement inside the Table of DB.
|
|
|
|
|
Performance wise there shouldn't be much of a hit for performance. If performance goes down the dumper, add a WHERE clause or an index.
For whatever odd reason, if you really wanted to resort the data based on the data column. Create a temp copy of the table, copy the data into it, delete the data from the orig, and then insert the databack into the orig and use the order by. Again, why you would want to do this is beyond me and really isn't needed.
Any suggestions, ideas, or 'constructive criticism' are always welcome.
"There's no such thing as a stupid question, only stupid people." - Mr. Garrison
|
|
|
|
|
Hey guys i am in confusion for VS 2008
i was using VS 2005 before
now i move to make new enhancement
please help me for making a student database for the timetable
|
|
|
|
|
download and setup SQL express
Create your database
create your tables
create your relationships
create your CRUD procedures
Nothing to do with VS
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Are you doing a Homework ?
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswam@its.co.za
|
|
|
|
|
hello
SQL Profiler been replaced in SQL 2005?
Thanks
dev
|
|
|
|
|
Nope look under tools, first menu item!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
That's SQL2000
What about 2005? I go Management Studio there's nothing there except:
1. External Tools
2. Customize
3. Options
Where is it in 2005?
dev
|
|
|
|
|
The very first item under Tools menu is Profiler.
C isn't that hard: void (*(*f[])())() defines f as an array of unspecified size, of pointers to functions that return pointers to functions that return void
"Always program as if the person who will be maintaining your program is a violent psychopath that knows where you live." - Martin Golding
|
|
|
|
|
I suggest you have a dodgy installation, it is there for both 2005 and 08.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Trace Start...
Yes.......profiler is in 2005.....agreed with Holmes that your install is probably hosed if you don't see it there.
Run the setup again and add it.
Trace Paused...
Any suggestions, ideas, or 'constructive criticism' are always welcome.
"There's no such thing as a stupid question, only stupid people." - Mr. Garrison
|
|
|
|