Viewing 15 posts - 61 through 75 (of 90 total)
You should be able to from a PowerShell window run the following and then do the notepad $profile thing.
New-Item $profile -force -type File
notepad $profile
August 8, 2012 at 9:20 am
Thanks. I will submit a change.
August 8, 2012 at 9:15 am
Thanks.
I will be posting some videos related to my stairway at my youtube channel http://www.youtube.com/dbaduck and at http://dbaduck.com as well.
I know Sean and have seen his...
August 8, 2012 at 8:44 am
Thanks. I have submitted to have the graphic re-added to the level.
August 8, 2012 at 6:53 am
The backup of the primary database is a backup of the secondary backup. You can get a backup of the Primary database with COPY_ONLY flag so that you don't...
June 26, 2011 at 11:47 pm
Typically port 1434 UDP is the port that SQL Server listens on for requests to SQL Server about configuration. The other port is used to connect to SQL Server.
The...
March 24, 2011 at 9:06 pm
;WITH CTE (Type, Code, Value)
AS (
SELECT [Type], [Code], [Value]
FROM dbo.A
UNION ALL
SELECT Type, Code, Value
FROM dbo.B
UNION ALL
SELECT Type, Code, Value
FROM dbo.C
)
SELECT Type,
[X], [Y], [Z], [V], [M], [N]
FROM (
SELECT Type, Code,...
January 4, 2011 at 3:32 pm
Well, the client OLEDB is going to always be separate than the Server DLL, so it will not matter as much that the Server dll is newer. It will...
January 4, 2011 at 2:12 pm
You should use SQL Configuration Manager and the nodes should be online. SQL Configuration Manager is the only way you should change SQL Server Service Account passwords.
January 3, 2011 at 9:56 pm
I think that we all agree that this is something that can be important, but there are many ways to get at information that will tell you what has been...
January 3, 2011 at 7:02 am
This is one way: (has to be 2005 and above), and remember that there are other ways too.
ALTER PROCEDURE [dbo].[usp_GetClassScheduleForProgramNClass]
@ProgramID int
AS
BEGIN
SET...
January 2, 2011 at 10:36 pm
Remember that statistics are telling SQL Server what kind of data exists in this column for the entire table. If you use DBCC SHOWSTATISTICS on the statistic set, you...
January 2, 2011 at 10:29 pm
The view is defined when you use CREATE VIEW and anything you do in there will be in effect on any call. If the view is queried from either...
January 2, 2011 at 10:25 pm
Is the application running on the SQL Server that is now 64 bit or are the application machine and the SQL Server machine separate machines?
January 2, 2011 at 10:20 pm
You would have a Main() function that would be the one that gets started when the script runs.
You can either do that or define all your functions as you did...
January 2, 2011 at 10:18 pm
Viewing 15 posts - 61 through 75 (of 90 total)