I want to share the script to upload files via FTP in SQL Server which need work directory to create a FTP command file to execute. This script will use ASCII transfer mode as a default to upload files. [CODE] DECLARE @FTPServer varchar(128) , @F...

I want to share the script to upload files via FTP in SQL Server which need work directory to create a FTP command file to execute. This script will use ASCII transfer mode as a default to upload files. [CODE] DECLARE @FTPServer varchar(128) , @F...

I want to share the script to upload files via FTP in SQL Server which need work directory to create a FTP command file to execute. This script will use ASCII transfer mode as a default to upload files. [CODE] DECLARE @FTPServer varchar(128) , @FTPU

I have just tried to connect SQL Server default local instance by providing "." as server name and able to connect. We can connect with "(local)" also.......

I have just tried to connect SQL Server default local instance by providing "." as server name and able to connect. We can connect with "(local)" also.......

Just learned from pinal's blog that by using SSMS, we can generate various reports also. Suppose, we can generate the report of top queries by average CPU Time or average IO Time etc. In SSMS, Right click on server name-> Reports -> Standard Re...

Just learned from pinal's blog that by using SSMS, we can generate various reports also. Suppose, we can generate the report of top queries by average CPU Time or average IO Time etc. In SSMS, Right click on server name-> Reports -> Standard Re...

What if you want to find out if a specific field contains a certain value? For example you want to find out all employees who have 0 vacation hours and 0 sickhours. Common way is to write a where clause with 'or'. Another way to do this is to use 'i...

What if you want to find out if a specific field contains a certain value? For example you want to find out all employees who have 0 vacation hours and 0 sickhours. Common way is to write a where clause with 'or'. Another way to do this is to use 'i...

What if you want to find out if a specific field contains a certain value? For example you want to find out all employees who have 0 vacation hours and 0 sickhours. Common way is to write a where clause with 'or'. Another way to do this is to use 'i...