Viewing 15 posts - 27,721 through 27,735 (of 39,803 total)
sp_changeobjectowner
you would not update system tables.
July 25, 2008 at 11:05 am
The DTS package will run under the credentials of SQL Agent as a job. You need to be sure that this account has rights to the database.
I think you might...
July 25, 2008 at 11:04 am
http://msdn.microsoft.com/en-us/library/ms188783.aspx
CREATE INDEX has a row and page level locking option. Someone created the index with it set to OFF.
July 25, 2008 at 10:59 am
Tools | Options | Results | SQL SErver | Results to Grid, there's a checkbox for results in a separate tab.
July 25, 2008 at 10:58 am
I love the argument a backup is needed?
I think your instructors are perhaps lacking some understanding of how SQL Server should be run.
July 25, 2008 at 10:55 am
I've done something similar to Jason in the past. having standard drive letters makes a huge difference since everyone knows backups are on "z"
Be sure that your arrays are physically...
July 25, 2008 at 10:53 am
If you detach it every time, you'll need to attach it again. It won't be in your list of databases.
What are you trying to do here? Meaning what's your process...
July 25, 2008 at 10:50 am
I agree with the advice above, but you might try simplying with a view or CTE for part of the query (either with or without the stock level). Sometimes breaking...
July 25, 2008 at 10:49 am
Getting references and using your network is important, but honestly, I'm mostly with Jeff. A good technical interview and my instincts are what I mostly use.
July 25, 2008 at 10:38 am
The rule is ALWAYS "It depends"
There are print servers that overload hardware and there are SQL instances that could run alongside almost any other software.
Virtualization is about using more of...
July 25, 2008 at 10:32 am
I think Americans in general are a little arrogant, and overall, culturally ignorant. We tend to see the US as the center of the world. There's some basis with our...
July 25, 2008 at 10:25 am
I have friends running production boxes as virtual servers, but they watch the loads for SQL Server. The SQL Servers don't float and share physical resources with lower use stuff.
Other...
July 25, 2008 at 8:30 am
What is your code?
xp_cmdshell is in master, so you might need to call it as
exec master.dbo.xp_cmdshell
July 24, 2008 at 10:48 pm
I haven't run them under load, but I tend to view these as Gsquared has mentioned.
July 24, 2008 at 10:44 pm
Viewing 15 posts - 27,721 through 27,735 (of 39,803 total)