Hi,
I'm trying to add a new Image type to the Picture Library. I like to add a .dng file to it and also to generate a thumbnail view voor this image.
How is this done for the .JPEG files and is it possible to do tis with other images which are not in the default list.
.DNG = adobe digital...
Hi,
It's possible to store the content outside the SQL database, and keep the DB small. We are using a provider to store the content on a external device and works fine!
look at http://www.stealth-soft.com
Microsoft like's it :-)
/Navmen
Hi Ian,
GREAT Job, I modified it to:
select sum(q.Size_MB)as Size_MB from (select distinct PhysicalFile, Size_KB/1048576 as Size_MB from STH_SQLDBSIZE) q
And got the toital size of all files.
Thanks,
Navmen
Some message on this query:
Msg 8155, Level 16, State 2, Line 7
No column was specified for column 2 of 'q'.
Msg 207, Level 16, State 1, Line 7
Invalid column name 'Size_KB'.
is a select after From supportd?
Thanks,
Navmen
Ian,
When I run this query I got the message :
Msg 156, Level 15, State 1, Line 4
Incorrect syntax near the keyword 'group'.\
When I remove Group By I got the message:
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near ')'.
Thanks,
Navmen
Ian,
Thanks,this gives the size of only one file.
The query: select distinct(PhysicalFile), Size_KB/1048576 from STH_SQLDBSIZE
Gives:
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\WSS_Content_Partners.mdf 0.08807373
C:\Program Files\Microsoft SQL...
Hi,
Still a small problem, how can I get the SUM of the Size_KB
select distinct(PhysicalFile), SUM(Size_KB/1048576) from STH_SQLDBSIZE
This still gives me the SUM of all the files, I need only from unique entries?
Thanks,
Navmen
Hi,
I try to get only one row from a table, when I run “select PhysicalFile, Size_KB from SQLDBSIZE” I get all the physical file locations:
C:\Program Files\Microsoft SQL Server\MSSQL. \MSSQL\DATA\WSS_Content_Partners.mdf
C:\Program Files\Microsoft SQL...
Yep, you are right.
This is the list we got from the DB
EX:"exMgr"</o=myexchange/ou=first administrative group/cn=recipients/cn=exmgr>
SMTP:"'John@hotmail.com'"<John@hotmail.com>
EX:"Jac Schmidt"</o=myexchange/ou=first administrative group/cn=recipients/cn=jac>...
:-) last question
we have also this string:
SMTP:"John McAen"<John_McAen@mymail.local>
or
NOTES:"Es ter Horst"<notes/IBM/Es >
with this current query I got :"John McAen or S:Es ter Horst
Can we remove text before the first " (and also the ")
Thnx,
NavMan
Thnx Borisiav,
But the string start with EX:"name"< > or SMTP:"name"< > etc
I got now EX:Irma Schmidt . How can I remove the words before the first "
Thanks
NavMen
Hi,
I'm trying to extract from the following string only the name: Irma Schmidt
String from the DB:
EX:"Irma Schmidt"</o=myexchange/ou=first administrative group/cn=recipients/cn=irma>
And when I'running the query I got 1000 mailaddresses from the DB and I like only the first 10.
Thanks...
Hi,
I try to update a table with the following query, the ShPath string is coming from a external source
UPDATE SHARES SET group='0' WHERE servername='SRV01' and ShPath = 'C:\USERS_100\'
But the ShPath has the entry C:\USERS_100 how can I remove the \ behind the C:\USERS_100\
Thanks,
Navmen
Hi
I try to collect all tranactions of today with the following query and that works fine, but now I try to get information from the last 7 days and I don't get it to work.
select * from STH_POL_REPORT where date = CONVERT(varchar(30),getdate(),101)
Date field format is: 02/28/2008...
Thanks for the answer, but the ' is still there
'"court"OR "judical" OR "case number"'
How to remove the leading and end ' from the string.
Thanks,
Navmen
Hi,
I'm trying to remove some characters from my text string below, with Right I can remove the word CONTAINS(', How can I remove with the same query the characters ') on the end of the string.
CONTAINS('"court" OR "judicial" OR "case number"')
select Right(POL_QUERY...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.