Viewing 15 posts - 31 through 45 (of 110 total)
quote:
I have been watching the deadlocks using Profiler and also DBCC TRACEON(1204,3605,-1) and have found that any statement that changes the status...
He who knows others is learned but the wise one is one who knows himself.
September 15, 2003 at 4:47 am
You are right Frank.
Actually Scheduler is a great out of the box tool provided with windows.
Pay Respect to People on your way up. For you will meet the same People...
He who knows others is learned but the wise one is one who knows himself.
September 15, 2003 at 3:47 am
I am not aware what sort of reporting you are planning at.
I had to work on a reporting app a few months back, What I did was I developed...
He who knows others is learned but the wise one is one who knows himself.
September 15, 2003 at 3:35 am
You can write your code in Visual basic and schedule it using NT-Scheduler.
Pay Respect to People on your way up. For you will meet the same People on your way...
He who knows others is learned but the wise one is one who knows himself.
September 15, 2003 at 3:12 am
Are you trying to connect through a machine other than the one on which sql server is installed. What Login Name are you using, since you have mentioned that you...
He who knows others is learned but the wise one is one who knows himself.
September 3, 2003 at 5:04 am
What is the error that you are getting.
If you are trying to connect using sa account under the security option set the authentication mode to both sql server and windows.
Pay...
He who knows others is learned but the wise one is one who knows himself.
September 3, 2003 at 1:23 am
Fully Agree to what steven and frank says.
Pay Respect to People on your way up. For you will meet the same People on your way down.
He who knows others is learned but the wise one is one who knows himself.
September 3, 2003 at 1:18 am
They are under the master database.
Pay Respect to People on your way up. For you will meet the same People on your way down.
He who knows others is learned but the wise one is one who knows himself.
September 2, 2003 at 11:17 pm
Try using the command object instead of the connection object, it is more Intuitive for stored procedures that return values.
Pay Respect to People on your way up. For you will...
He who knows others is learned but the wise one is one who knows himself.
September 2, 2003 at 10:41 pm
Try using the command object instead of the connection object, it is more Intuitive for operations stored procedures that return values.
Pay Respect to People on your way up. For you...
He who knows others is learned but the wise one is one who knows himself.
September 2, 2003 at 10:41 pm
Try this example
create procedure p @p1 varchar(100)
as
exec('select * from ' + @p1 + '.dbo.sysobjects')
Pay Respect to People on your way up. For you will meet the same People on...
He who knows others is learned but the wise one is one who knows himself.
August 31, 2003 at 11:39 pm
This are my details
7 years of IT experience that consists of web application development using ASP, IIS, COM+, SQL Server, VBScript and JavaScript and n-tier business applications development using COM,...
He who knows others is learned but the wise one is one who knows himself.
August 31, 2003 at 10:24 pm
One way is to set the isolation level to the highest i.e. seriallizable.However this may result in command time out,so you may need to increase the command time out of...
He who knows others is learned but the wise one is one who knows himself.
August 31, 2003 at 10:19 pm
How About this
declare @j-2 int
declare @i int
set @j-2=1
declare a cursor for
select [column] from order by [column]
open a
fetch next from a into @i
while @@fetch_status=0
begin
if @i<>@j
begin
break
end
set @j-2=@j+1
fetch...
He who knows others is learned but the wise one is one who knows himself.
August 29, 2003 at 4:43 am
Information about foreign keys is stored in sysreferences table.
The colums fkeyid and rkeyid are the objectid's of the referencing table and the referenced table respectively.
Pay Respect to People on your...
He who knows others is learned but the wise one is one who knows himself.
August 29, 2003 at 2:55 am
Viewing 15 posts - 31 through 45 (of 110 total)