Viewing 15 posts - 31 through 45 (of 45 total)
Orlando & Jacob, thanks a million.
The 3-part naming helped. I appreciate the support.
February 1, 2016 at 5:05 pm
Thanks Orlando for your prompt input and for your recommendation in regards to using obsolete code.
However, the error is the same.
"The target database, 'PapersDB' (not the realDB), is...
February 1, 2016 at 4:42 pm
Aside from the @ sign and .com (gov,edu), What would be considered invalid.
It would probably check e-mail structure (but I don't even think it checks for that).
Since it is...
January 14, 2016 at 12:43 pm
Are you thinking of traditional Clustering with Shared Storage or Always ON Availability Group Clustering nonshared storage?
January 11, 2016 at 3:19 pm
SQL Server Agent > Properties > Alert System >Enable mail profile
January 11, 2016 at 2:15 pm
Did you enable the Mail Profile in the SQL Server Agent Properties?
January 11, 2016 at 2:13 pm
You might want to create an SSIS package to run a cmd or powershell script that will delete the files or do multiple file system tasks to delete specific files.....
January 11, 2016 at 1:54 pm
AlwaysON includes 2 or more servers. When attaching/restoring the DB, SQL adds some information that is unique. The old file does not have that new information. When you do a...
December 18, 2015 at 3:21 pm
When joining a Database to an AlwaysON Group it needs to be in (1) Full Recovery mode (2) have a Full Backup.
When you restore the database to SVR1 you need...
December 18, 2015 at 3:16 pm
So you went from A to B.
Then you went from B back to A.
All Databases except for one came ONLINE.
The one you are having problem says INITIALIZING.
OK.
The last...
October 28, 2015 at 12:40 pm
I usually use SSMS to create a VIEW where I write my query and make sure there are no empty values. It seems you are reading from live data...
October 13, 2015 at 5:49 am
If you create VIEW with the Query you mentioned (That will be your Dataset).
Now you should be able to reference one DATASET from your Report.
October 9, 2015 at 9:53 am
SSRS is independent from the SQL Engine. It does not have to be installed on the same Server as the SQL Engine. Just do a normal SQL install process on...
October 9, 2015 at 9:48 am
You can only have ONE PRIMARY Server (you can READ/WRITE).
You can have multiple SECONDARY (READ only).
You have a One Way Replication A (Primary) to B (Secondary).
The only problem...
April 23, 2015 at 12:44 pm
Viewing 15 posts - 31 through 45 (of 45 total)