Exact number of records?

Is the spreadsheet in compatibility mode by chance?

Please provide ddl and the error message you are getting.

I completely disagree.

Only for the sake of creating discord, malcontent, and to be argumentative because there is nothing in the question to whine about otherwise.

What version of SQL Server? What is the file extension of excel you are using (xls limits to ~65000 records where xlsx limits to ~1,000,000).

If you have more than...

Jeff Moden (1/9/2013)

---

fearghalreilly (1/9/2013)

---

In one of my tests I was asked this question

you are working as part of the database team for the zoro online company . a junior database...

That is the way it was designed in SQL Server.

jitendra.padhiyar (1/9/2013)

---

Is it dynamic change ? I mean if I will lower down the max memory, Will SQL server will release...

dwain.c (1/9/2013)

---

Lynn Pettis (1/9/2013)

---

dwain.c (1/9/2013)

---

I was referring to this in my prior post:

long time, experienced and heavily qualified...

Too Late!:rolleyes:

😉

You can do any of the following:

Logon Trigger

Database/Server Audit

That is if the logon you are seeking is a database logon or a server logon. If the logon is within...

Stefan Krzywicki (1/9/2013)

---

A few months ago we ordered a pizza and it took forever to arrive, so we called the place to ask what the delay was. We were told...

Liptons

And when you've been bit?

Grey Cup

During index rebuilds, yes I would change the log backup to every 5 minutes. Once finished, then revert back to the old schedule.

If you use one of the preferred...