Viewing 15 posts - 34,891 through 34,905 (of 39,723 total)
Beta is due out anytime. May/June for B2 was the last we heard.
As far as the help, it's built around the Codewise community. Both Whidbey (new Visual Studio) and SQL...
May 24, 2004 at 8:11 am
We are as well!
,
The new help system in the product includes searches on various communities, including this one. Check it out!
May 21, 2004 at 11:09 am
Personally I think Yukon will require more DBA work. Adding all that into the RDBMS will create more and new issues, require more control of changes, and require the DBA...
May 21, 2004 at 11:04 am
From some searches, it appears nobody knows. In fact, you seem to have more information than most. Care to write an article on your experiences?
May 21, 2004 at 7:52 am
I haven't seen this, but the general network error means the server didn't repond to a request. From what you have listed, it's possible you have some structural problem that...
May 21, 2004 at 7:45 am
That is possible that the firewall needs to be changed. SQL Server communicates on 1433 and 1434, so you might need them opened. Are you accessing the SQL server on...
May 21, 2004 at 7:42 am
I've had strange jobs like this as well. Some type of bug is all I can figure. There is a "run once" option, so be sure that isn't checked.
Other than...
May 20, 2004 at 7:42 am
Very good, there are two functions suser_name() and suser_sname() that return different values. Both are affected in SQL2K by Setuser.
May 20, 2004 at 7:39 am
Do you have any additional extended stored procedures or other software on your sql server? If you don't and can't isolate to a particular process, you need to call Microsoft...
May 20, 2004 at 7:36 am
I hope you're not really using XP
, that's a big problem right there.
I definitely get values for these columns. I'd suspect something is wrong...
May 20, 2004 at 7:30 am
There might be one in the script library, but what you're asking for is a role. That's why roles exist and why you should use them.
http://www.sqlservercentral.com/columnists/sjones/wp_userrights.asp
May 20, 2004 at 7:27 am
I'm not sure you can tell on the 10sec mark, but you could setup a 2nd job to run and check the output from sp_help_job for your specific job having...
May 20, 2004 at 7:21 am
Depends on what you want. I've tended to include the used and free amounts and a change from the previous day so I can see if things are growing abnormally.
what's...
May 19, 2004 at 11:16 am
If you don't need password recovery, there is an encrypt() function that does a one way encryption.
May 19, 2004 at 11:03 am
There isn't a way. however you can generate a script to do this automatically.
declare mycurs cursor for
select name from sysobjects
where type = 'p'
and name not like 'dt%'
declare @nm varchar(50)
, @cmd...
May 19, 2004 at 10:55 am
Viewing 15 posts - 34,891 through 34,905 (of 39,723 total)