Viewing 15 posts - 41,611 through 41,625 (of 49,571 total)
pat (1/18/2009)
Names must be in two-part format.
As the error says. 3-part naming is also not allowed. Hence, only objects within the same database.
Edit: There's a long list of restrictions...
January 18, 2009 at 2:14 pm
Garadin (1/18/2009)
Is that ever the case though? =).
Maybe. There's more than one company I know where the access control doesn't allow two entrances one after the other. If you swipe...
January 18, 2009 at 1:26 pm
A normal query isn't schema bound.
A simple view is not schema bound.
Both of those will run fine when referencing another server.
The restriction is that you cannot reference a remote...
January 18, 2009 at 1:05 pm
Yeah, true.
Even so, the only extra checks (afaik) that are added once checkdb with data purity has run successfully are the ones that you turn on by adding the...
January 18, 2009 at 1:03 pm
As the error says, you're not allowed to access a remove server in an object that's created WITH SCHEMABINDING.
January 18, 2009 at 12:18 pm
MichaelJasson (1/18/2009)
Do we need to restart the sql service everytime we enable any trace or this is applicable to only some of the traces?
If you enable the traceflag using DBCC...
January 18, 2009 at 12:15 pm
That's actually not that hard, providing it's impossible to have two sequential in's or out's and the first entry is going in.
Pseudocode:
SELECT * FROM
(SELECT *, ROW_NUMBER OVER (PARTITION BY EmployeeID...
January 18, 2009 at 12:08 pm
Ok.....
Since the OrderNo (in event items) is a != in the query, it's absolutely senseless to have it as the leading column. It means that SQL has to do a...
January 18, 2009 at 11:36 am
Two excellent places to look for details on the storage engine - http://blogs.msdn.com/sqlserverstorageengine/default.aspx and http://www.sqlskills.com/blogs/paul/
January 18, 2009 at 11:18 am
Cast them to numeric(9,2) before casting to varchar. It will cause the value to be rounded and then displayed with 2 decimals.
eg: replace CAST(DeliveredQty AS VARCHAR(10)) with CAST(CAST(DeliveredQty AS NUMERIC(9,2))...
January 18, 2009 at 11:15 am
krypto69 (1/18/2009)
January 18, 2009 at 11:14 am
For what it's worth, if I had that error on a production database, I'd pick the second option if it was feasible (due to time constraints). Or you can just...
January 18, 2009 at 11:13 am
MichaelJasson (1/18/2009)
I shall always keep default trace running to avoid such happenings.
The default trace won't avoid such happenings. It'll only tell you who did it. The default trace (as it's...
January 18, 2009 at 10:58 am
Unfortunately, with that error you only have two options.
1) Edit the system tables directly to remove the orphaned records (very tricky, as the system tables are very complex on SQL...
January 18, 2009 at 10:57 am
Almost. What do you want the results to look like?
p.s. Can you put that lot into a code block so it doesn't cause scrolling?
January 18, 2009 at 10:44 am
Viewing 15 posts - 41,611 through 41,625 (of 49,571 total)