When you define the log shipping, you define it at a database level and not at a server level. This means that on both servers you can have primary...

There is no such thing as array in SQL. The closest thing can be a temporary table or a table variable.

Adi

ODBC is not a database. ODBC is a standard for database access. There is an ODBC driver that can be used to any database that supports this standard...

Try to modify your code like this:

Declare @Report_Date VARCHAR(11);

SET @Report_Date = CONVERT(varchar,GETDATE()-1,101);

INSERT INTO table2 (Report_Date,CR_GP,Cr_Grp_TTCount)

SELECT Top(10) @Report_Date, CR_GP, COUNT(DISTINCT TID) AS TTCount

FROM table1.dbo.db1

WHERE (CONVERT(nvarchar, DATEADD(s, CREATE_DATE, CONVERT(DATETIME, '1970-01-01 00:00:00',...

You have to understand that the more details that you write, the more chances are that someone will be able to help you. Currently all we know is...

This is just to add a bit on Chraig’s answer. Using dynamic SQL has its own price in terms of security and query plan usage. I strongly advice...

How do you pull the data? Where are you pulling it from? What is the data type of the original source?

Adi

You can define scheduled tasks in SQL Server. I suggest that you’ll look for reading material about Jobs and SQL Server agent in order to learn how to schedule...

I didn’t try it, so I can’t tell you for sure that it works, but if I had to come up with a solution for it, I would have try...

It looks like there is a DDL trigger on create login statement. The trigger produces the runtime error and preventing you from adding a new login. Check the...

I’m sorry, but I do think that this is not logical to expect that the server will get all formats of dates and interpret all of them correctly. I...

I don’t know if you know it or not, but when you rebuilding an index takes it offline while it is being rebuild. If it is a cluster index,...

While I agree with Jack that you shouldn’t use the option of auto_close for the databases, I don’t think that this is the cause of your problems. When user...

If you mean for difference between

Select WhatEver from MyTable where ID in (1,2,3)

And

Select WhatEver from MyTable where ID = 1 OR ID=2 OR ID=3

Then both will produce the same...

Nice demo. Defiantly proves the point. I have to admit that it did surprise me, but every day I learn something(s) new

Adi