When I saw the code Getting All the Information of the Server in SQL Server – MSSQL Query, I thought to share mine.This more or less sums the general MS SQL instance information Good Luck
When I saw the code Getting All the Information of the Server in SQL Server – MSSQL Query, I thought to share mine.This more or less sums the general MS SQL instance information Good Luck
When you create a Linked Server on SQL Server, some users may get this error: EXECUTE denied on object ‘xp_prop_oledb_provider’, database ‘mssqlsystemresource’, schema ‘sys’. So, the only thing you need (if you have set up your permissions correctly on Linked Server) is to run the following code: GRANT EXECUTE ON SYS.XP_PROP_OLEDB_PROVIDER TO LOGIN; …
Ok, since I have Windows 8 couple of months, I would like to share some things with you. First of all, it took me some time to find out where shut down, restart or log off is… Log off (sign out) or switch user On Start screen / Metro screen, right click on user: Shut …
I had my SSRS running smoothly, but there was one thing bothering me. That was email sender friendly name. In RS Configuration Manager you can setup e-mail settings, and enter senders e-mail address. But every time I got an email with report, the sent from stated sql@sqlreports.com. But I need an friendly name. So, I …
I don’t know why, but for some reason, my Windows 8, has disabled DELETE confirmation dialog. So this is little know how, how to enable it. Right click on Recycle Bin, then properties. And, on the bottom you can enable Display delete confirmation dialog Good Luck
Hi, this short post will be about my new phone, a little review after couple of weeks of owning it. LINK This mobile phone is on Android 4.0 OS. It works with dual SIM cards, and the price is reasonable. Plus sides: Price cca 200€ – very very reasonable price SIM Manager – handles …
How to get list of jobs an their steps. For this I will use three tables dbo.sysjobs, dbo.sysjobsteps and dbo.sysjobschedules in msdb database. You can create select from each of these tables to get relevant data. select name,enabled,description from msdb.dbo.sysjobs select job_id,step_id,step_name,command,database_name from msdb.dbo.sysjobsteps select job_id,next_run_date,next_run_time from msdb.dbo.sysjobschedules But we can combine these three …
Have you ever tried to connect to AS400. It’s been a hassle for me. But finally I got it to work, so let me share little of my wisdom with you. First create linked server, then change options to it. EXEC master.dbo.sp_addlinkedserver @server = N’AS400′, @srvproduct=N’i520′, @provider=N’IBMDA400′, @datasrc=N’AS400′, @provstr=N’User Id=USER;Password=PWD;Default Collection=DAT;’ Change option: USE [master] …
For table comparison, i like to use Red Gate SQL compare. Great tool, but if you don’t have money for it, you can always try to write your own comparation script. You can then script it as function, and use it. It does not have, options like SQL Compare, but for now it will do …
Recently, I was asked a question, how to send notification to multiple users. First you must create operator in SQL Agent. In field “E-mail name:” you enter multiple e-mails, divided by semicolon (;). And then you just have to set notifications in Agent Job Good Luck
I recently installed Windows 8 Enterprise in my company. During the installation, setup does not require input of serial number/key. So when Windows installs, you must go through procedure of changing the key, and activating Windows. So here it goes. On Desktop, go with your mouse to bottom left corner. When Start icon pops up, …