Viewing 15 posts - 5,116 through 5,130 (of 5,356 total)
Hi to all,
quote:
Obviously America is the king of the acronymn world. I seem to remember that one of the US Navy...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
June 2, 2003 at 1:11 am
Hi Joseph,
agree with Andy. Blob's aren't always bad, though sometimes it seems to me like a philosophical question whether to store binary data in a db or on the file...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
June 2, 2003 at 1:02 am
Hi ljmonteiro,
quote:
a5xo3z1 use a "status" field ( I add also a timestamp , and a user field ). But adding a column...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
June 2, 2003 at 12:40 am
Hi Bavineni,
quote:
Is there any site like this for java/c++.
Antares686 reminded me of http://www.codeguru.com. for C++.
If...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
June 2, 2003 at 12:27 am
Hi jrose,
quote:
Just to verify - Does the Date Time Modified only get updated when an Auto Grow takes place or when the...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
June 2, 2003 at 12:15 am
Create a job
Add a step
Name it what you like
type Transact-SQL Script
choose appropriate db
type 'EXEC sp_name'
schedule it to run daily at your time
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
May 28, 2003 at 8:25 am
Hi Patrick,
quote:
I have worked with several project managers who maintained this facade of not dealing with the day-to-day grind of actually writing...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
May 28, 2003 at 7:51 am
Hi ramesh_kondaparthy,
DECLARE @text varchar(8000)
SELECT @text=<your_textfield> FROM <table>
Now you should do your manipulation
At the end there (should?) be a UPDATE <table> SET <textfield> = @text
I'm not quite sure on this for...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
May 28, 2003 at 7:30 am
Hi DRBuckingham,
quote:
Also, the date/time stamp of the files change when you stop/start your SQL Server (or a reboot occurs).
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
May 28, 2003 at 7:24 am
I think going the way to first learn to hand code and then move to something visual is better then vice versa. Take away the visual tools and see who...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
May 28, 2003 at 7:18 am
Hi dbaguy,
quote:
We keep the member list page deleted because we don't want our members to be spammed by a program that scans...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
May 28, 2003 at 6:49 am
This is getting really interesting.
We should make a competition from it. Who's next? ![]()
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
May 28, 2003 at 3:58 am
I increased the default value only in a small self-made tool that stores (large) binary data into one certain db. If filesize gone beyond ~5-6 MB I ran into timeout...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
May 28, 2003 at 3:43 am
Hi hoodg,
MSDN says default value is 15 seconds for connection Timeout (CommandTimeout = 30 seconds).
Maybe you need to increase also CommandTimeout like this
With cnnAttach
.CommandTimeout = your...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
May 28, 2003 at 3:09 am
Hi David,
quote:
Hey try this surreal solution. I doubt perfomance would justify it.
your solution has indeed...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
May 28, 2003 at 2:50 am
Viewing 15 posts - 5,116 through 5,130 (of 5,356 total)