Viewing 15 posts - 241 through 255 (of 629 total)
What you mean no protocols if the Protocol NET Libraries are missing you'll have to reinstall to get them fixed.
To add an aliases do this:
1) Run SQL Server Configuration Manger.
2)...
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]
March 25, 2009 at 12:56 am
Please don't cross post, replies here.
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]
March 25, 2009 at 12:50 am
Try ...
SELECT TOP 50 qs.total_worker_time / execution_count as avg_worker_time,
(SELECT SUBSTRING(st.text,
...
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]
March 25, 2009 at 12:45 am
I am taking a guess you meant 16774776 KB which is (~16GB).
So if you have 16GB, and you set SQL Server's max memory to 14,000MB (13.67GB); the rest of...
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]
March 25, 2009 at 12:35 am
If you got the security settings already right only mistake I see is the quotes are in wrong place ...
Change
@query = 'xp_cmdshell type "P:\Userdb\Output\OD.out"'
to
@query = 'xp_cmdshell ''type P:\Userdb\Output\OD.out"'
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]
March 25, 2009 at 12:12 am
IF OBJECT_ID('tempdb..#TT') <> 0
Drop Table #TT
Declare @CombinedValue varchar(255)
CREATE TABLE #TT (Col1 int, Col2 varchar(2))
Insert Into #TT Values (1,'1')
Insert Into #TT Values (1,'2')
Insert Into #TT...
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]
March 24, 2009 at 11:58 pm
Or timeouts from long waits. Please check Link; I posted a link there you use to check for blocking issues.
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]
March 24, 2009 at 11:49 pm
Thats Microsoft's party line, if it is not SP4 it is not supported. Because if you run into issues and you are not SP4 they can't say the issue was...
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]
March 24, 2009 at 11:45 pm
If you are having timeout because of blocking you can use the sp_blocker_pss80 (http://support.microsoft.com/kb/271509) here to try to find out what is causing the issue.
Be warned this produces a lot...
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]
March 24, 2009 at 11:41 pm
You have to use a proxy account when executing the xp_cmdshell extended stored procedure. Please look at http://www.databasejournal.com/features/mssql/article.php/3789881/Proxy-Accounts-in-SQL-Server.htm.
Thanks :).
Mohit.
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]
March 24, 2009 at 11:15 pm
Yes it is not "advised" as means to permanent solution to avoid updating/fixing your code. Compatibility mode was designed so your upgrade processes becomes less painful. "Use sp_dbcmptlevel...
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]
March 24, 2009 at 11:04 pm
I don't believe LIKE and CHARINDEX will use the FULL TEXT Index; the keywords to use a FULL TEXT index are, contains, containstable, freetext, and freetexttable.
Thanks.
Mohit.
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]
March 24, 2009 at 10:52 pm
This article (http://support.microsoft.com/default.aspx/kb/910230) is showing you how to do it using GUI not command line. HTA is a HTML file that can be executed; thats all. After you...
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]
March 24, 2009 at 10:46 pm
Abi Chapagai (3/24/2009)
hi Mohit:Thanks for the response. I am trying to monitor following items:
1. Logins
2. Logouts
3. Loginfailed
Possible using http://www.sqlservercentral.com/articles/SQLServerCentral/sqlserver2005logontriggers/2366/ article (very good article)
4. Exixtence of users or...
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]
March 24, 2009 at 10:43 pm
Mh (3/24/2009)
This gives all the columns from table1 and table2, I only need the ones with differences. Thanks.
I see if you need such detail I would recommend looking at RedGate...
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]
March 24, 2009 at 6:55 pm
Viewing 15 posts - 241 through 255 (of 629 total)