Viewing 15 posts - 496 through 510 (of 588 total)
Which version of windows? Windows 2003 a mapped drive is session specific, so running anything against a mapped drive will not work from within SQL.
April 5, 2007 at 6:59 am
Only time I shrink is if for some reason I have been in a database causing it to grow more than normal. For example during a change to a table...
April 5, 2007 at 6:56 am
Not sure what you meant with the follow up question. Using a variable in top is new in 2005 yes.
You could write a select statement like this.
Select @var, column1, column2...
April 4, 2007 at 8:51 am
April 4, 2007 at 8:27 am
Try this:
From SSMS
Right click on the server name and click properties
Click on the Permissions tab
Click the user name
On the Explicit Permissions almost at the bottom there is "View Any Definition"...
April 4, 2007 at 6:45 am
Found the answer myself. You do not need to buy a new license.
http://www.microsoft.com/sql/howtobuy/default.mspx
April 3, 2007 at 2:25 pm
Only way *I* have found to do close to what you want is using the for XML path, but I do not think that is available in SQL 2000.
Doing
select...
April 2, 2007 at 12:50 pm
Some value you are trying to convert can not be converted to datetime datatype.
April 2, 2007 at 11:55 am
See if this is what you want. To read the XML in an easier way run the query into a grid then click on the XML and it will be...
April 2, 2007 at 11:54 am
Most likely by the time you think the data is going to be inconsistent it will be too late to do a backup that will do you any good (there...
April 2, 2007 at 9:34 am
I used toi be all work and no fun, then realized there just is a lot more to life than work.
For fun I play computer games (mostly MMORPG's), but to...
April 2, 2007 at 6:17 am
I think every serious delay I have ever seen in all the projects I have been involved in has been due to scope creep, which I guess comes right back...
March 29, 2007 at 1:52 pm
have you even tried the code I posted? It should do what you are saying you need. It could be optimized a bit by using top 1 after using a...
March 28, 2007 at 1:19 pm
I have the same issue, in SP2 the added FULLSCAN to the criteria, which was not there before with no SP. So maybe full scan was not the default value...
March 28, 2007 at 7:45 am
Why would it matter if you send it all in XML or just the line items if you are not storing it as XML?
March 27, 2007 at 7:16 am
Viewing 15 posts - 496 through 510 (of 588 total)