No...

Lynn Pettis (4/24/2012)

---

You need to specify the columns of the table you are inserting the data into. Although your first colum,n is an identity column, it is being counted...

Don't do a batch file... Create a job with an...

You are saying that if the backup location fails, you want it to try another location? If so, don't use a maintenance plan, use a script that can handle this.

Not completely sure... do you have identity insert on? Have you tried qualifying the insert statement and see if that helps?

Why don't we all try waiting for the answers to the basic questions before firing off "supposed" solutions. It will keep this thread cleaner and get down to the real...

I don't think you were poking fun at anything. You have valid points. I think it really all comes down to the specific situation, but also personal preference. I...

John Mitchell-245523 (4/24/2012)

---

All that casting from int to to varchar looks messy to me -...

Also, look at the difference between server roles and database roles. There are different ones for each (some similar though). Obviously, one is at the server level, independent of...

I believe that dts is now MsDtsServer100 (10.0) and MsDtsServer110 (11.0). Full Text Indexing is MSSQLFDLauncher. So I think the monitor is looking for specific service names that...

Did you do your upgrade on the day that is referenced as the last day the services were running? Is everything running correctly now? Those would be my first 2...

vahid.arr (4/23/2012)

---

hi everybody

i have table with 45 field.if i want break it in two or three table. i will face problems in working with this table (inserting,updating,deleting,searching with hard query).is...

Dev (4/23/2012)

---

SQL Server rewrites the query to optimize it so the predicate in the outer query (for view) can be moved to inner query (view definition). It’s very much dependent...

The synonym... Yes. It is simply another name for the object. EDIT: removed some info that I realized was the wrong path of thinking for this...

They're grayed out because you cannot change the properties either at all or from this window. This is the "database" user, not an...