Setting Up Multimedia Database (Including Photos)
May 24, 2015I am new to sql server and i would like to set up a multimedia database (includes photos) using sql server (regardless of the version). How can i achieve that?
View 3 Replies
ADVERTISEMENT
Creating Slideshow By Accesing Photos Through Sql Database
Jan 11, 2005hi all
am trying to create slideshow by accesing photos through sql database ...Please help me
Thanks a lot in advance
Saving Images Or Multimedia Files In SQL Server
Feb 16, 2005Hi !!
If i want to save, images, video clips or movies ......(multimedia stuff) in the SQL Server. Any idea how can i save them and call them. I also, want to know if that the effecient way to the task or there are other ways to di it???
Thanks!!!!
Retrieving A File Link From The Database And Including Its Code On Page
Dec 21, 2004Hi there folks,
was just wondering if there was an easy way to include a files contents into a web page via a database field. A bit confusing i know.
Here goes:
I got a field called ContentPage stored in a database. (e.g Index.htm)
I want to retrieve this page and then include its contents in my middle div of the webpage like so: <!--#include file="<%=ContentPage%>"-->. Not allowing me to do this as you may have guessed. These pages will either be htm or aspx pages. This would make my life so much easier.
Is there any way of doing this or am i kidding myself.
Would appreciate any help.
Paul
Moving Database Server From WIN2k To WIN2003Advanced 64 Bit Including System DB's
Dec 12, 2007Hi
Today I have task to move all UDB's including matser,msdb form Windows 2000 server to Windows 2003 Advacned Server with 64bit(8 Hours Down time)
Present Plan
1.Install same Version of SQL Server in Destination Server
2.Take all Databases Backup
2.Move DTS,JOB and Scripts with same location
3.Stop both servers SQL Server's
4.Deattch all Databses and Move to Destination Server
5.Place all Databases(Same Loaction i.e Soruce Server master DB is C:<folders>.. Place in Destination Server C:<folder>..)
6.Start the Databse Servers(Destination)
7.Port the Apllication and Test.
Note:for our project we are using windows users,so that no problem with Orphan users.
Please some body Advice me, or suggest me
..it is ok
Photos
Jun 20, 2004hi
im developing a student database application in VB & Sql Sever2k. to prepare the identitiy card for students, their photos must be stored in a separate table. can any one tell how to store and retrieve photos in the database ?
thanks in advance......
How To Use Transfer SQL Object To Copy An Entire Database Including Logins And Users
Dec 14, 2007
I have read the previous threads on the bugs with this task mainly: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1438968&SiteID=1 . These are great posts that helpmed me avoid wasting time. I haven't seen one yet that addresses copying an entire database including the sql server logins.
I would like to import the ENTIRE database from one (2005) server to another(2005) using the SSIS Transfer SQL Object task (not just sprocs,tables,views and functions). I have figured out how to pull the tables,views,sprocs and functions ... by using an execute sql task to drop these objects. But I cannot get this to work for users since the user dbo cannot be dropped and guest can only be disabled. I am creating a new database (this is the database where the sql objects will be copied to) via management studio to test this. There has to ba a way to get this working ... Microsoft must have published some sort of KB article on this task or a Script Task using SMO object calls. If need be I can drop the entire database on the target machine and have SSIS recreate it.
The only reason I'm willing to take a risk with SSIS rather than backup and restore is because of time constraints (I assume the SSIS task is faster) and backup storage administration.
declare @name varchar(200)
declare @object varchar(200)
DECLARE object_cursor CURSOR READ_ONLY FORWARD_ONLY FOR
select table_name,table_type from INFORMATION_SCHEMA.TABLES
union
Select name,'SPROC' table_type from sys.procedures Where [type] = 'P' and is_ms_shipped = 0 and [name] not like 'sp[_]%diagram%'
union
select name,'FN' from sys.objects where type_desc like '%FUNCTION'
OPEN object_cursor
FETCH NEXT FROM object_cursor INTO @name,@object
IF @@FETCH_STATUS <> 0
PRINT ' <<None>>'
WHILE @@FETCH_STATUS = 0
BEGIN
if @object = 'BASE TABLE'
begin
exec ('drop table ' + @name)
end
else if @object = 'VIEW'
begin
exec ('drop view ' + @name)
end
else if @object = 'SPROC'
begin
exec ('drop procedure ' + @name)
end
else if @object = 'FN'
begin
exec ('drop function ' + @name)
end
FETCH NEXT FROM object_cursor INTO @name,@object
END
CLOSE object_cursor
DEALLOCATE object_cursor
New SQL Server And Photos
Jul 23, 2005I heard that you can store photos with the row in the new SQL Server (aphoto data type?). Is this true? If so, is there a speed advantage ifyou have an e-commerce platform with thousands of products?Help appreciated.Thanks,Frank*** Sent via Developersdex http://www.developersdex.com ***
View 2 Replies View RelatedAdding Photos To SQL Table
Jul 23, 2006Hello all I am new to this site.
I am trying to use ASP.NET to build an application but I am not sure
how to add photos and other data to the sql table that I have created.
Thanks in advance.
Merge Replication And Photos
Nov 16, 2007Hi,
I am developing an application which will take photos using Windows mobile and upload those pictures in the main server using merge replication .
Is there any rule of thumb that suggests the size of photos that has to get merged? Like the number of photos , size of photos , quality of photos , the practical transfer rate over GPRS technology in U.S ?
Please advise...
Photos In SQL Server: Store As Images Or Strings With Path && Filename?
Apr 4, 2008Hi, for my photo album database I'm trying to decide whether to store the actual photos as images in the db or whether to leave them in file directories with just the path & filename in the db. As a beginner in this field I don't know how either of these options compare (e.g. in terms of performance, complexity, flexibility and maintainablity) so any advice on the pros and cons of each would be appreciated.
View 5 Replies View RelatedThree Table Join - Display Newest Comments Left On Photos Created By Members
Jul 6, 2014I am trying to tweak some code which is used to display the newest comments left on photos created by my members.
The existing code is this:
SELECT top 15 pnumber,pcomment,puser FROM photocomments order by pdate DESC
So the latest comment left was for photo #210879 from user "Cla" (redacted user names). The 2nd newest comment would be for photo #211072 from a member named "mo". pdate is a date field
However for the script I have coded I don't want all of the photo comments to show up. This is because I use access levels based on the type of location (higher levels mean more restricted galleries). I check the access levels as I go through the recordsets.
I use this method to get the top 15 comments:
SELECT top 15 pnumber,pcomment,puser FROM photocomments order by pdate DESC
Now I have to use two other tables to determine the access level. Since PHOTOCOMMENTS is just a list of photo #'s and the people who left comments for those photos, I need to:
a) determine what location the photo is from and
b) determine the access level of that location
I use: select creator,access from locations where id=(select dir from photos where id="&pnumber&")"
This is a two step process as you can see. The first part is:
select dir from photos where id=(pnumber)
ID is the same value as pnumber seen in PHOTOCOMMENTS. That is to say PHOTOS.ID = PHOTOCOMMENTS.PNUMBER
If I haven't confused you yet, the executed code for the first example would be:
select dir from photos where id=210879
which would get me a value for DIR. DIR is the location number which would be:
select creator,access from locations where id=(dir value)
Just to simplify it a bit....
There are three tables (shown below)
PHOTOCOMMENTS
PHOTOS
LOCATIONS
I need to: SELECT top 15 pnumber,pcomment,puser FROM photocomments order by pdate DESC (first table shown)
but then also
select creator,access from locations (The last table shown)
where id=(select dir from photos where id="&pnumber&")"
So the first table PHOTOCOMMENTS has to also join PHOTOS table where PHOTOS.DIR = PHOTOCOMMENTS.PNUMBER in order to get the value of "DIR" and then DIR is joined to the LOCATIONS tables where PHOTOS.DIR = LOCATIONS.ID
Here is the actual code, which I am trying to make into a single SQL command
strSQL = "SELECT top 15 pnumber,pcomment,puser FROM photocomments order by pdate DESC"
set ors = oconn.Execute(strSQL)
tl = 0
do until ors.eof or tl > 15
' until we have 15 results because not every recordset will be of the proper security level
[Code] ....
Bonus points if you can also get it to select from LOCATIONS only WHERE userlevel >= 2
Setting SQL Database So That Cold Fusion Will Go To New Database Instead Of Master
Apr 17, 2001whenenver i run cold fusion, it automatically gets my tables out of the master database instead of the new one i have created. i've added a user that has a default to the new database instead of the master, but i need to know how to use that new user correctly, and what i will need to do once i start adding more databases so that cold fusion will go to the appropriate database and not to the master.
View 3 Replies View RelatedSetting Up SQL Database
Apr 7, 2007I have been using MySQL as the back end of my .Net 2.0 applications for a while using a custom membership provider without any problems.Having now switched to a new webhost which supports both MySQL and MS SQL Server 2005 and also creating a new site thought I should set up the new site to use MS SQL..... I am having trouble however setting up the SQL server to act as the membership provider. Following the advice on here I tried using aspnet_regsql.exe... Firstly, when trying to get the list of databasses on the remote server I get the following error: Failed to query a list of database names from the SQL Server. Invalid object name 'Sysdatabases' If I then just type in the name of my database and go through to the end I get the following error:Exception:An error occurred during the execution of the SQL file 'InstallCommon.sql'. The SQL error number is 8152 and the SqlException message is: String or binary data would be truncated. I can connect to my MS SQL server remotely without any problem using the likes of MS SQL Server Management Studio Express. Is there any other way I can setup the databases needed for user and roles access control or is the usage of MS SQL much more complicated than what MySQL was?
View 4 Replies View RelatedDatabase Setting
Dec 9, 2004. The BPA recommend that the model database setting for the items below be set to on. I can accomplish this task through the query analyzer and run the set command. (Set ANSI_NULLS on). The response is positive but when I re-run the report the setting are back off.
Why???
•QUOTED_IDENTIFIER
•ANSI_NULLS
•ANSI_WARNINGS
•ANSI_PADDING
•ANSI_NULL_DFLT_ON
•CONCAT_NULL_YIELDS_NULL
Setting Up A Database
Feb 20, 2006Hi people,
I'm in the process of trying to set up my first SQL Server database and things aren't going as per the book! (surprise, surprise).
The 'Identity Specification' option during Table creation, is 'greyed out' and won't let me set (Is Identity) to 'Yes' or anything else for that matter.
I guess that there's a simple answer to this one, but as a newbie to SQL Server ( and VB 2005) I'm curently at a loss.
Can anyone point me in the right direction?
Niknek
Setting Database Data
Apr 4, 2008I'm having trouble changing data in my database. It is actually a VB cuestion, but you see, i just finished lesson 9 of the begginers Visual Basic 2005 video series and in my last run i can't save the data i've changed into the database. no errors are shown, it just does't change the values.
i know for a fact that the code is well written and there is no problem with the configuration of buttons and such, because i folowed the steps 50 times so I believe it must be a SQL configuration problem.
does anybony have any insight on what the problem might be.
THX malcolm
Readonly Setting For Database
Jan 29, 2004we have a database that only serves Select requests (no OLTP) for our very high traffic websites.
what are the benefits of turning on read-only setting for the database if there are no transactions occuring in the database?
does sql server put locks on tables for SELECT statements?
is it the same as using HINT (NOLOCK) ?
thanks
stephane
Setting Up Database On A New Server
Feb 23, 1999Hi,
There has been a lot of discussion about moving single databases or devices in same server. Can someone suggest the most simplest method to set up a identical server with all the logins, permissions and password etc?
Building a new server with sp_help_revdatabase and dumps/loads is relatively easy but moving the master is confusing to me. I should run the new server and databases for a little testing period (with diffrent server name, of course) and then go live by dropping the old and by adding the new. I remember someone said that this would be as easy as copying master.dat to new machine (when servers are identical), any experience or other suggestions?
TIA,
Al
Setting Database Priority
May 9, 2006Hi all.
Does anyone know how to set a database priority? I have a SQL Server that contains multipule databases. One of the databases is very high priority. I need to make sure that no matter what is running on the server that this database's processes take priority and nothing slows it down.
Thanks.
Default Database Setting
Mar 18, 2015Is there any practical downside to setting ANSI_NULLS and QUOTED_IDENTIFIER to ON at the database level? Almost all devs will simply leave these default settings at the top of a stored proc script anyway.
View 2 Replies View RelatedCheck For A Database Setting
Feb 14, 2007I want to query my databases to find out if Auto Shrink is set. I know the status column in sysdatabases holds this value as a bit setting but I don't know how can I check this value using a query.
Canada DBA
Connecting Without Setting Up A Database Possible?
Nov 28, 2007Hello everyone, I am fairly new to SQL Server Express and I have a question I was hoping someone could help with. I know this will sound very wacky but please entertain the possibility of such scenario taking place...
Is it possible to connect to an instance of an SQL Server Express 2005, using asp, without having a database created and without configuring anything such as permits or users first ?
The SQL Server Express was installed on a PC that runs a web server as well but nothing else was done, I only have the instance name and I know the SQL Server is configured for local access only.
I was hoping to create a database and begin using it with an asp file that runs SQL commands I can input on a text window, but I can't find connection strings that work without specifying a database name, and also I don't know which user and password to use because it is set to windows authentication.
I thought the code would go something like this:
Set cn = Server.CreateObject("ADODB.Connection")
cn.Open "Driver={SQL Server};Server=SQLinstance;Address=localhost,port;Database=;Uid=;Pwd="
To top things out the web server is configured to send out a generic error message, so I can't see what the error I'm getting actually is...
Any thoughts ?
Thanks.
Setting Password For Each Database
Jul 23, 2005Hi,When I create a new database from Enterprise Manager (right click ondatabases > New Database) I noticed that I am not prompted to create apassword or user name. Can I take it then that all databases under thesame local group will have the same password and user name?I have tied to access the newly created database using the samepassword and username but haven't had any luck.Thanks
View 3 Replies View RelatedSetting Up Database Snapshot
Oct 26, 2007I have created a snapshot
CREATE DATABASE AdventureWorks_Snapshot1200 ON
(NAME = N'AdventureWorks_Data', FILENAME=
N'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataAW_1200.ss')
AS SNAPSHOT Of AdventureWorks
I changed the records
AddressLine1
from 1970 Napa Ct. to 1970 Napa Ct. Apt 1
When i run
select * from Person.Address
AventureWorks_Snapshot1200 where addressid = '1'
select * from Person.Address
AventureWorks where addressid = '1'
Both appear as 1
When i change Apt to 2 and run it both appear 2
Changed again to 3 both appeared as 3 too.
I was under the impression that the snapshot would remain as 1 when the new update 2 has been performed.
Any light be appreciated.
Setting Up A Database Copy.
Mar 31, 2008
Hi all :-)
I am new to Sql server and hope that someone in here might be able to help me out with a little advice on how to go about how to achive the following.
My boss wants me to set up a copy of one of our production databases, the copy is supposed to be used for running questions against thru businessobjects. There will be aprox 10 simultanious users, the original and the copy must never be further apart in time then 15 min. The database is today about 25 gigs and to make it even more complicated the copy must be available at all time during business hours (8-17). The solution is also supposed not to influence the production databases perfommance to much (really low impact to the performance is a key issue).
The options I have thought of is:
1. Use mirroring and then take a snapshot of the mirror for the users to connect to.
2. Replicate only the data that is needed.
3. Log shipping in a combination with the online restore option in sql 2005 server.
4. Log shipping and then take a snapshot of the copy for the users to connect to.
I have also thought about if the need for current data is that high it might even be better to let them run their questions directly against the production db instead since there will not be so many simultanious users.
Any of you guys that have any ideas, all tips will be very appreciated!
Thanks in advance :-)
/Wandy
Setting Up/accesing Database In VB Codebehind
Jul 9, 2006Hey All,
I'm very new to ASP.NET and have recently begun using the databinding functionality. So far, all I've had to do is drag and drop the various controls and then use the data source wizard to set up an appropriate query. However, now I've got a bit of a different need. In the VB codebehind, i need to be able to ask whether something is true in the database, and then if it is, carry out functions. So, for example, what I need to do is:
if (SQLStatement "Select charttype FROM charts WHERE datasource = " & dropdownlist1.selecteditem.tostring()) Then
'do whatever
end if
Trouble is, I don't know how I would go about binding the data so that I could access it in this way. Any guidance would be very much appreciated.
Thanks,J Rankin
Other Way Of Setting Current Database In SQL Script
Nov 7, 2001Hi,
I'm trying to create an SQL script that creates a new login account for each of our databases. The one remaining problem with the sql is it could not set the current database using a variable(e.g. USE @dbasename). I tried looking for another way of setting the current database but could not find one.
Is there any other way of setting the current database other than the USE command?
Any help/suggestion will be appreciated.
Thanks in advance,
Julius
Setting The Defualt Database In SQL 2005
Mar 28, 2006Its not a big deal but enoying enought that i always have to
USE MyDatabase
-- Instead of having it set as the defualt and not adventureworks
Changing Database Collation Setting?
Mar 6, 2012I currently have a server with the collation set to SQL_Latin1_General_CP1_CI_AS.
However, some of the databases within the server are set to Latin1_General_BIN, probably because they were restored from another server some time ago. Also, even within the databases that have Latin1_General_BIN, some of the columns are set to SQL_Latin1_General_CP1_CI_AS, very confusing to say the least.
What i would like to do is change the database collation settings for these databases to match the server setting. I would also like to change all of the tables within these databases to have the columns also set to the server collation settings.
I'm looking for the steps that i would need to take to make sure i don't mess anything up as these databases have there own sets of views and sp's that run each day.
Setting User Name && PWD On SQL Express Database
Dec 6, 2005How do you set a user name and password on a SQL Express database created using the data explorer in VB2005EXP?
View 1 Replies View RelatedSetting A Maintenance Plan For A SQL Database In The SERVER
Jun 10, 2007I learned how to make SQL database BACKUPs through Maintenance Plans in SQL server 2005 in my own computer.
So my question is: When I finally would be deploying my ( asp.net 2.0) web site in a distant real server, how could I set a Maintenance Plan there ?
Easy Problem, But Need Help With Setting Up Database Keys.
Jan 29, 2008I need help setting up my primary keys for a database table. Suppose I have two tables, as listed below. The first one isa table of students and the course they are enrolled in. The second table is a table of test scores. Never mind that this could be designed better. Please just using my design as an example, I need help.
First table - Student Table
Student Id Student Course Building1 Joe Math101 Primus Hall2 Jake Engl103 Indigo Hall3 Mary Art107 Money Hall
So my question is the following. On my second table below, can I just haveone Key as the Primary key? Just like in the first table. I will have a primary key named "TestId"
If so, how do I set up my table so that the values in the "TestId"table will be automatically generated upon inserting into the Testscore table.
Second table - Tests Score Table:
TestId StudentId TestScore Date 1 1 99 9/1/07 2 1 100 9/15/07 3 1 88 9/16/07 4 2 99 9/1/07 5 2 100 9/15/07 6 2 88 9/16/07 7 3 79 9/1/07 8 3 100 9/15/07 9 3 100 9/16/07