Forum Replies Created
Viewing 15 posts - 5,941 through 5,955 (of 7,499 total)
-
RE: Reindex log
you can write the job-step-output to a txt-file (edit jobstep-properties \ advanced). Maybe that already gives you the info you need.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: MS SQL Service and Agent
- You should run sqlserver using an "own" sqlserver-domain account that serves only that sqlserver (or a group of sqlservers if you want to)
- Be carefull when changing the serviceaccount...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: .NET application, timeout period elapsed
I guess not, because the .commandtimeout is available with the sqlclient.sqlcommand.
I would be estonished if that wasn't integrated in DAAB.
They've found it for the connection, so they 'll be...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: .NET application, timeout period elapsed
With ado.net there is a sqlcommand.CommandTimeout that you can set.
also check out
http://msdn2.microsoft.com/en-us/library/aa479373.aspx#spoil_topic4
http://msdn2.microsoft.com/en-us/library/aa479373.aspx#spoil_topic5
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: .NET application, timeout period elapsed
Indeed, it's the dba's daily job to do miracles and salvations
Dev-teams are first of all afraid to admit flaws, and then to...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: Building a Distributed Service Broker Application
Good article.
Most articles only handle "local" SSB. That's the easy part !
There are many pitfalls when going remote.
I'll poste al litle script containing the dmv's,.. for SSB-problemsolving.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: How do I put together two sql Inner joins?
The way Santosh wrote it , you'd get two resultsets.
If you want to join both queries to get one resultset , just use :
SelectStatement = String.Format("
SELECT ....
FROM shows AS...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: .NET application, timeout period elapsed
if you use a command-object, it has its own timeout (default at 30seconds)
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: .NET application, timeout period elapsed
can you also post the query ?
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: .NET application, timeout period elapsed
- start sql-profiler to capture a sample load and examine it for table and or index scans.
- do you have db-maintenance-jobs in place ? to reduce fragmentation
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: Database Restore for SQL 2005 Enterprise...
- for the data-part the is no difference for 32 or 64-bit OS / SQLServer
- however if you are using the CLR, I guess it would be nice to avoid...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: Triggers
- I wouldn't advise a trigger for this purpose ! (start job) because if the start job fails, your transaction fails !
- I woudn't advise a trigger for this purpose...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: Optimizations job error message
this could be your test-script ....
print '00 Creating dbo.test';
go
create table dbo.Test (col1 int not null )
go
print '01 inserting rows into dbo.test';
go
insert into test values(1);
go
print '02 Selecting from unqualified table test';
go
select...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: Error 21776: [SQL-DMO] The name ''''dbo'''' was not found in the Users collection
I guess that's what the "true" parameter is for in
use exec sp_changedbowner 'sa', true.
You can use sp_changeobjectowner @objname = 'oldowner.object' , @newowner = 'newowner'
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: How to query file name used for a particular backup?
making this #é&() mistakes, you can immagine the rest of my day
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
Viewing 15 posts - 5,941 through 5,955 (of 7,499 total)