Viewing 15 posts - 616 through 630 (of 1,884 total)
Natalie,
Paste the following in the Notepad, save it as a file name CheckModifyDate.vbs:
If IsLatest("C:\z_MyLog1.txt") = "False" Then
MsgBox "Your file was not modified today!"
Else
MsgBox "Your file was modified today!"
END IF
'----------------------------------------------------------------------
Private...
September 5, 2006 at 1:44 pm
1. Try to use Cient Network Utility Aliases for each Named Pipes and TCP/IP
2. Try to use Fully Qualified Domain name.
3. Try to ping the server.
Let us know if any...
August 31, 2006 at 3:26 pm
It works for me. I am connecting is as my Windows login that is a Windows administrator on SQL Server 2000 server.
August 31, 2006 at 3:16 pm
You can put a message on the login page that your site will be down during certain hours a couple of days in advance.
August 29, 2006 at 10:05 am
What happens when you copy the same file on both machines? Does it take the same time or one server is faster? Check performanc counters for Physical Disk and for...
August 25, 2006 at 4:17 pm
Luke,
check also how much memory and what are the CPUs, how many threads. The easy way to check is Task manager that will show you all CPU threads and memory...
August 25, 2006 at 11:11 am
I don't think that this article says that we can do it. I would use third-party tools like ERwin or ERstudio to do that. Another alternative is to create diagrams in...
August 21, 2006 at 4:05 pm
Mark,
I am able to create database diagrams connected as db_datareader user. Books Online say in the article
"Understanding Database Diagram Ownership (Visual Database Tools) "
http://msdn2.microsoft.com/en-us/library/ms186345.aspx
August 21, 2006 at 2:38 pm
Barry,
I think I got it.
I have 2 roles: Role1 and Role2. Both roles have DBO as the owner. Role1 owns Schema1 that contains Table1. If I try to grant Select on...
August 21, 2006 at 1:50 pm
Check the permissions. If the differece between running and not running package is the person who executes it then there are server or database permissions. Check the identity the first...
August 21, 2006 at 9:49 am
I understand that SA is not for 3 years since SW is purchased but as they explained to me it is valid as long as SA is included in the...
August 18, 2006 at 10:32 am
Does the application use Integrated to connect ot the database or the application uses Integrated to login to the application and then uses a hardcoded login name and password to...
August 17, 2006 at 11:41 am
I tested it and it is like that. I created everything: a schema, a table, a role exactly as Barry describes, went to Securables tab, added permissions to the role...
August 17, 2006 at 9:39 am
Dan
What was the utility?
August 17, 2006 at 9:20 am
Viewing 15 posts - 616 through 630 (of 1,884 total)