Viewing 15 posts - 16 through 30 (of 629 total)
I don't keep each patch downloaded, I usually do try to keep my environments the same version. I know it is difficult and outright impossible in some business cases.
But...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
September 1, 2010 at 10:01 am
A bit different...
EXEC sp_detach_db 'DBName'
Thanks.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
August 23, 2010 at 7:51 pm
1) Databases cannot be located at UNC path when attaching SQL Server will not allow it.
2) After installing SQL Server Express on the computer you can just use following connection...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
August 20, 2010 at 3:23 pm
[font="Courier New"]
SELECT 'ALTER LOGIN [' + name + '] WITH PASSWORD=N''password'''
FROM MASTER.sys.server_principals
WHERE TYPE = 'S' AND principal_id <> 1
[/font]
Pretty much what has been said just without help of excel...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
August 20, 2010 at 3:03 pm
Only other thing I can suggest is try removing him from group and re-adding it? My last job the ad guy knew how to check if security token were...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
August 20, 2010 at 2:36 pm
should be security.
Please check when he attempts a logon to SQL Server in Windows Security logs Login any kerberos issues recorded?
I don't think it can be this issue as no...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
August 20, 2010 at 10:42 am
This is a very open ended question, trying to answer how to do performance tuning is not easy. But for starters I would recommend checking your database servers, check...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
August 20, 2010 at 9:54 am
Hmm no SSPI errors, users defaults are correct, hmmm
If user is able to access it directly and not via AD group.. there is one other issue have found. If...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
August 20, 2010 at 9:49 am
Sorry for late reply.
Well its not as scary as it looked, heh I didn't know you already multiplied by 1000, so I was worried a bit heh.
Drive D seems to...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
August 20, 2010 at 9:46 am
I have weird errors like that too, are there any SSPI errors logged?
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
August 18, 2010 at 11:20 am
Answered in here.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
August 18, 2010 at 11:11 am
Correct, because dynamic management views are not real objects. They are exposing the underline information with in SQL Server. In this particular DMV, the statements actually get pulled out...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
August 18, 2010 at 11:10 am
saravanansoft (8/18/2010)
SET @sql = 'CREATE LOGIN ' + @UserName + ' WITH PASSWORD= ''TestUser123'',CHECK_POLICY = OFF'
EXECUTE(@SQL)
.....
CREATE LOGIN TESTUSER With PASSWORD =...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
August 18, 2010 at 11:07 am
State 11 indicates she doesn't have access to her target database/default database. So when you add her manually is her default database different?
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
August 18, 2010 at 11:04 am
Notes on Disk subsystem troubleshooting, the spike in usage is not a concern.
You should look at the average over a fixed time, aka when your systems were the most...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
August 18, 2010 at 10:21 am
Viewing 15 posts - 16 through 30 (of 629 total)