Author: admin

SQL SMSS connect as another Windows NT user

I tried to find out how to connect through SMSS to SQL server as another domain user. You must run SMSS as “RUN AS..” so the code is as follows: runas /netonly /user:domain\user “C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Ssms.exe”   EDIT:!! Due to version changes: %windir%\System32\runas.exe /netonly /user:domain\user “C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe -S SERVER” EDIT!! When …


T-SQL: Get number from string

Mail merge from SQL Database mail

E-mails in MSSQL– How to setup Database Mail

Teamviewer – a great ad-hoc support

As I wrote earlier in my blog post Working with Batch, we had a problems connecting to all computers in our branch offices. Since we live on VPN, provided by ISP on his modems/routers, there was always war with theirs technicians. First of all, we had an old software Symantec PCAnywhere 11 which we used …


Setup Win7 or Win8 from USB drive

Space, the final frontier….

TSQL – working with folders and output to file

Rename SQL Server 2008 – standalone

Simple Calendar–first thing in BI reporting

When you are building or creating rudimentary BI for someone, there are always some parameters you have to embed in your query. But, almost always there is date to date parameters. So, it is very helpful to have a calendar table, where you know which days are weekends, which days are working days, what week …