In query analyzer I can not see the templates, clicking on the various
folders does nothing. The tql files DO exist in the templates folder and I
have double checked that QA is looking at the correct folder. I can use the
templates from the menu, but I just can not see them in the folder tree. Any
ideas on how to fix this annoying problem?
Files are hidden or something like that?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Dean" <Dean@.discussions.microsoft.com> wrote in message
news:B0EA84C1-D862-42CA-8C92-9E727982F187@.microsoft.com...
> In query analyzer I can not see the templates, clicking on the various
> folders does nothing. The tql files DO exist in the templates folder and I
> have double checked that QA is looking at the correct folder. I can use the
> templates from the menu, but I just can not see them in the folder tree. Any
> ideas on how to fix this annoying problem?
|||Not hidden, but compressed. Thanks for the idea to look at the other
attributes. This has been driving me crazy.
"Tibor Karaszi" wrote:
> Files are hidden or something like that?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Dean" <Dean@.discussions.microsoft.com> wrote in message
> news:B0EA84C1-D862-42CA-8C92-9E727982F187@.microsoft.com...
>
>
Showing posts with label files. Show all posts
Showing posts with label files. Show all posts
Friday, March 9, 2012
Saturday, February 25, 2012
q; delete files
I need to delete all the *.txt file in a specific folder modified date is
older than 2 months,. How can I do this in a stored procedure?JIM.H. wrote:
> I need to delete all the *.txt file in a specific folder modified date is
> older than 2 months,. How can I do this in a stored procedure?
http://realsqlguy.com/serendipity/a...th-The-Old.html
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||If you are capable of SQL Server 2005 you would do that the best with a
CLR procedure. Looping though the files collections and delewting the
appropiate files.
HTH, Jens Suessmyer.
http://www.sqlserver2005.de
--
older than 2 months,. How can I do this in a stored procedure?JIM.H. wrote:
> I need to delete all the *.txt file in a specific folder modified date is
> older than 2 months,. How can I do this in a stored procedure?
http://realsqlguy.com/serendipity/a...th-The-Old.html
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||If you are capable of SQL Server 2005 you would do that the best with a
CLR procedure. Looping though the files collections and delewting the
appropiate files.
HTH, Jens Suessmyer.
http://www.sqlserver2005.de
--
q; delete files
I need to delete all the *.txt file in a specific folder modified date is
older than 2 months,. How can I do this in a stored procedure?JIM.H. wrote:
> I need to delete all the *.txt file in a specific folder modified date is
> older than 2 months,. How can I do this in a stored procedure?
http://realsqlguy.com/serendipity/archives/9-Out-With-The-Old.html
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||If you are capable of SQL Server 2005 you would do that the best with a
CLR procedure. Looping though the files collections and delewting the
appropiate files.
HTH, Jens Suessmyer.
--
http://www.sqlserver2005.de
--
older than 2 months,. How can I do this in a stored procedure?JIM.H. wrote:
> I need to delete all the *.txt file in a specific folder modified date is
> older than 2 months,. How can I do this in a stored procedure?
http://realsqlguy.com/serendipity/archives/9-Out-With-The-Old.html
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||If you are capable of SQL Server 2005 you would do that the best with a
CLR procedure. Looping though the files collections and delewting the
appropiate files.
HTH, Jens Suessmyer.
--
http://www.sqlserver2005.de
--
Monday, February 20, 2012
Q: Trying to make Word (.doc) archive SQL 2005 webapplication
Hi all,
I am about to start writing an application to archive MS word files to
SQL 2005 DB. I have read few things about full text search. I only
need text search on these word files. Any good websites with info on
how to configure SQL 2005 and sample scripts. Application will be in
ASP 2.0.
Any good webpages and online document would be welcome. MS SQL 2005
online docs are not that great when it comes to word document text
search.
One thing that I am not sure about is, do I need to manually re-index
document every so often, or they are index and updates by them self.
Regards
Sadik
try this here:
http://media.techtarget.com/searchSQLServer/downloads/insider_fulltextsearch_0121.pdf
http://www.zetainteractive.com - Shift Happens!
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Sadik" <sadik007@.gmail.com> wrote in message
news:716459d8-ede7-41e7-847b-c966c540468f@.t1g2000pra.googlegroups.com...
> Hi all,
> I am about to start writing an application to archive MS word files to
> SQL 2005 DB. I have read few things about full text search. I only
> need text search on these word files. Any good websites with info on
> how to configure SQL 2005 and sample scripts. Application will be in
> ASP 2.0.
> Any good webpages and online document would be welcome. MS SQL 2005
> online docs are not that great when it comes to word document text
> search.
> One thing that I am not sure about is, do I need to manually re-index
> document every so often, or they are index and updates by them self.
> Regards
> Sadik
I am about to start writing an application to archive MS word files to
SQL 2005 DB. I have read few things about full text search. I only
need text search on these word files. Any good websites with info on
how to configure SQL 2005 and sample scripts. Application will be in
ASP 2.0.
Any good webpages and online document would be welcome. MS SQL 2005
online docs are not that great when it comes to word document text
search.
One thing that I am not sure about is, do I need to manually re-index
document every so often, or they are index and updates by them self.
Regards
Sadik
try this here:
http://media.techtarget.com/searchSQLServer/downloads/insider_fulltextsearch_0121.pdf
http://www.zetainteractive.com - Shift Happens!
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Sadik" <sadik007@.gmail.com> wrote in message
news:716459d8-ede7-41e7-847b-c966c540468f@.t1g2000pra.googlegroups.com...
> Hi all,
> I am about to start writing an application to archive MS word files to
> SQL 2005 DB. I have read few things about full text search. I only
> need text search on these word files. Any good websites with info on
> how to configure SQL 2005 and sample scripts. Application will be in
> ASP 2.0.
> Any good webpages and online document would be welcome. MS SQL 2005
> online docs are not that great when it comes to word document text
> search.
> One thing that I am not sure about is, do I need to manually re-index
> document every so often, or they are index and updates by them self.
> Regards
> Sadik
Q: TRN backup files
Hello,
In my backup maintenance, I have set deletion of backup files after 3 days,
it works for complete backup but not for transaction backup. (I see *.BAK are
removed, *.TRN are still there) what is problem?
Thanks,
Jim.Perhaps the plan involves trying to do log backup for databases which are in simple recovery mode?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:E03BBDB2-3ACF-4656-9BDE-1BB596DA74D9@.microsoft.com...
> Hello,
> In my backup maintenance, I have set deletion of backup files after 3 days,
> it works for complete backup but not for transaction backup. (I see *.BAK are
> removed, *.TRN are still there) what is problem?
> Thanks,
> Jim.
>|||where can I check if it is in recovery mode?
"Tibor Karaszi" wrote:
> Perhaps the plan involves trying to do log backup for databases which are in simple recovery mode?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
> news:E03BBDB2-3ACF-4656-9BDE-1BB596DA74D9@.microsoft.com...
> > Hello,
> > In my backup maintenance, I have set deletion of backup files after 3 days,
> > it works for complete backup but not for transaction backup. (I see *.BAK are
> > removed, *.TRN are still there) what is problem?
> > Thanks,
> > Jim.
> >
>
>|||yes you were right, the database is in full mode, other databases are in
simple mode, what is difference? If simple mode, is it not recoverable? I do
not see any TRN files if the database is in simple mode, is this a problem?
"Tibor Karaszi" wrote:
> Perhaps the plan involves trying to do log backup for databases which are in simple recovery mode?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
> news:E03BBDB2-3ACF-4656-9BDE-1BB596DA74D9@.microsoft.com...
> > Hello,
> > In my backup maintenance, I have set deletion of backup files after 3 days,
> > it works for complete backup but not for transaction backup. (I see *.BAK are
> > removed, *.TRN are still there) what is problem?
> > Thanks,
> > Jim.
> >
>
>|||mmm. I was reading it, I guess I need to keep it in full mode, but how far
does this TRN file go, is there a limit, or can we create a limit?
"Tibor Karaszi" wrote:
> Perhaps the plan involves trying to do log backup for databases which are in simple recovery mode?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
> news:E03BBDB2-3ACF-4656-9BDE-1BB596DA74D9@.microsoft.com...
> > Hello,
> > In my backup maintenance, I have set deletion of backup files after 3 days,
> > it works for complete backup but not for transaction backup. (I see *.BAK are
> > removed, *.TRN are still there) what is problem?
> > Thanks,
> > Jim.
> >
>
>|||This is a too big topic for a newsgroup conversation. I suggest you read in Books Online about how
backup and restore work in SQL Server.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:2734BEE1-0312-45BE-B1F2-5EEFD6450A69@.microsoft.com...
> yes you were right, the database is in full mode, other databases are in
> simple mode, what is difference? If simple mode, is it not recoverable? I do
> not see any TRN files if the database is in simple mode, is this a problem?
> "Tibor Karaszi" wrote:
>> Perhaps the plan involves trying to do log backup for databases which are in simple recovery
>> mode?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> http://www.sqlug.se/
>>
>> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
>> news:E03BBDB2-3ACF-4656-9BDE-1BB596DA74D9@.microsoft.com...
>> > Hello,
>> > In my backup maintenance, I have set deletion of backup files after 3 days,
>> > it works for complete backup but not for transaction backup. (I see *.BAK are
>> > removed, *.TRN are still there) what is problem?
>> > Thanks,
>> > Jim.
>> >
>>
In my backup maintenance, I have set deletion of backup files after 3 days,
it works for complete backup but not for transaction backup. (I see *.BAK are
removed, *.TRN are still there) what is problem?
Thanks,
Jim.Perhaps the plan involves trying to do log backup for databases which are in simple recovery mode?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:E03BBDB2-3ACF-4656-9BDE-1BB596DA74D9@.microsoft.com...
> Hello,
> In my backup maintenance, I have set deletion of backup files after 3 days,
> it works for complete backup but not for transaction backup. (I see *.BAK are
> removed, *.TRN are still there) what is problem?
> Thanks,
> Jim.
>|||where can I check if it is in recovery mode?
"Tibor Karaszi" wrote:
> Perhaps the plan involves trying to do log backup for databases which are in simple recovery mode?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
> news:E03BBDB2-3ACF-4656-9BDE-1BB596DA74D9@.microsoft.com...
> > Hello,
> > In my backup maintenance, I have set deletion of backup files after 3 days,
> > it works for complete backup but not for transaction backup. (I see *.BAK are
> > removed, *.TRN are still there) what is problem?
> > Thanks,
> > Jim.
> >
>
>|||yes you were right, the database is in full mode, other databases are in
simple mode, what is difference? If simple mode, is it not recoverable? I do
not see any TRN files if the database is in simple mode, is this a problem?
"Tibor Karaszi" wrote:
> Perhaps the plan involves trying to do log backup for databases which are in simple recovery mode?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
> news:E03BBDB2-3ACF-4656-9BDE-1BB596DA74D9@.microsoft.com...
> > Hello,
> > In my backup maintenance, I have set deletion of backup files after 3 days,
> > it works for complete backup but not for transaction backup. (I see *.BAK are
> > removed, *.TRN are still there) what is problem?
> > Thanks,
> > Jim.
> >
>
>|||mmm. I was reading it, I guess I need to keep it in full mode, but how far
does this TRN file go, is there a limit, or can we create a limit?
"Tibor Karaszi" wrote:
> Perhaps the plan involves trying to do log backup for databases which are in simple recovery mode?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
> news:E03BBDB2-3ACF-4656-9BDE-1BB596DA74D9@.microsoft.com...
> > Hello,
> > In my backup maintenance, I have set deletion of backup files after 3 days,
> > it works for complete backup but not for transaction backup. (I see *.BAK are
> > removed, *.TRN are still there) what is problem?
> > Thanks,
> > Jim.
> >
>
>|||This is a too big topic for a newsgroup conversation. I suggest you read in Books Online about how
backup and restore work in SQL Server.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:2734BEE1-0312-45BE-B1F2-5EEFD6450A69@.microsoft.com...
> yes you were right, the database is in full mode, other databases are in
> simple mode, what is difference? If simple mode, is it not recoverable? I do
> not see any TRN files if the database is in simple mode, is this a problem?
> "Tibor Karaszi" wrote:
>> Perhaps the plan involves trying to do log backup for databases which are in simple recovery
>> mode?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> http://www.sqlug.se/
>>
>> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
>> news:E03BBDB2-3ACF-4656-9BDE-1BB596DA74D9@.microsoft.com...
>> > Hello,
>> > In my backup maintenance, I have set deletion of backup files after 3 days,
>> > it works for complete backup but not for transaction backup. (I see *.BAK are
>> > removed, *.TRN are still there) what is problem?
>> > Thanks,
>> > Jim.
>> >
>>
Subscribe to:
Posts (Atom)