2880 2
how to take back up of all sql server databases?

I am using SQL server 2012 right, and I would like to know how can I take back up of all MS SQL server databases using a single script? or you can explain me a simple method.

 

...
Type
Question
2865 0
Free SQL Server Reporting Tools
In this article, I have provided list of free SQL server reporting tools with their features, so you can easily which sql server reporting tool will be good for your company.
Type
Article
2862 1
Error "Login failed. The login is from an untrusted domain and cannot be used with Windows authentication." in SQL server

I was trying to run my amazon RDS account using MS SQL server management studio, and was able to login succesfully but when using that values in web.config and loading page in browser, I am getting error as below

"Login failed. The login is from an untrusted domain and cannot be used with Windows authentication."

How Can I resolve this issue, here is my Connection string

...
Type
Question
2837 0
Get Date From Datetime in SQL Server
In this article, I have mentioned how to get date from datetime in sql server using various examples.
Type
Article
2833 0
Convert Month Number to Month Name in SQL
In this article, I have mentioned, how we can convert month number to month name in sql server, mysql and oracle database.
Type
Article

2818 0
Get month and year in sql server from date
In this article, I have mentioned how we can get month and year in sql server from datetime or date value.
Type
Article
2778 2
How to count the occurrence of specific word inside a string in sql server 2008?

Hi. Suppose, I have for example this string field in my sql database  "never say never"  and I want to count how many times "never" appear in the string in sql server 2008, so how I can check that.

Thanks.

...
Type
Question
2708 1
Query doesn't work with AVG function, how to use AVG in SQL?

I am trying to run the below query which works fine without AVG function, but when using AVG it doesn't work, here is the query

...
Type
Question
2660 0
Import data from Excel to SQL Server
In this article, I have provided step by step procedure to import excel in SQL Server database using SSMS or using SQL Query.
Type
Article
2638 0
Import an SQL file in MySQL (Using CMD or Powershell)
In this article, I mentioned how we can Import an SQL file in MySQL (Using CMD or Powershell or using MySQL Workbench) easily and quickly.
Type
Article

Page 7 of 11