Viewing 15 posts - 35,491 through 35,505 (of 39,720 total)
for the first one, you need a table alias, so
select a.* from (select....) a
where a.cnt > 1
For the 2nd, look up CAST in BOL.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server...
December 29, 2003 at 9:30 am
Is Auto Update statistics turned on?
It's an interesting question and I thought that reindexing would fix the statistics as well with a new sampling, but perhaps not.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of...
December 29, 2003 at 9:27 am
I'm guessing that the osql isn't evaluating the variable properly. Does it invoke other items? Like osql -smyserver -u%username%?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 29, 2003 at 9:24 am
I wouldn't put it on NAS. We've had issues with backups to network drives for the reason that SQL Server is not very tolerant of network delays. I wouldn't want...
December 29, 2003 at 9:21 am
I like the title change idea. We'll take a look at that.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 29, 2003 at 9:19 am
You can by placing an xp_cmdshell in the trigger, but be careful. The trigger will not complete and the transaction will not complete until the program finishes, which means locks...
December 26, 2003 at 11:34 am
Agree and thanks for the note.
Thanks to all for their contributions and thanks that my family, friends, and partners are healthy!
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 26, 2003 at 11:32 am
Don't grant to users, use roles.
That being said, the permissions matrix is by user/role by object, so you'd probably want to query for a specific object to see the permissions....
December 26, 2003 at 11:30 am
you can do it with DMO (I think Andy has an article on this) and then run the script from a job.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 -...
December 22, 2003 at 3:42 pm
@##^%$$#%$#%#
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 22, 2003 at 11:28 am
1. I've seen this as well and I have no idea. Some piece of code in the Optimizer is not working as expected.
2.
. send to sqlwish@microsoft.com
3....
December 22, 2003 at 11:27 am
Most likely the file is in use by some process, either the backup process or some tape process.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 22, 2003 at 11:22 am
I use ASP to query the db and pull stuff out. Visual Studio will help here. I'm sure there are some commercial utilites (http://www.mylittletools.net/scripts/en/home/) and others that can help.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The...
December 22, 2003 at 10:06 am
it should be rolling back the transaction and you will have to wait until it completes.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 22, 2003 at 10:02 am
Viewing 15 posts - 35,491 through 35,505 (of 39,720 total)