sql server - Referencing another table in T-SQL not working -

-

i've been running query on large number of servers, , on 3 of them (sql2000, sql2005 , sql2008) query fails. i've boiled down referencing table in db.

select * master.dbo.syslogins syslogins

which works on 99% of servers, on 3 gives:

invalid object name 'master.dbo.syslogins'

if switch master db , run

select * dbo.syslogins syslogins

then works. i've checked have permissions running

select is_srvrolemember('sysadmin');

which returns 1. why referencing master.dbo.syslogins table fail?

maybe server set case sensitive collation. try

select * master.dbo.syslogins


Comments

Post a Comment

Popular posts from this blog

Failed to execute goal org.apache.maven.plugins:maven-surefire-plugin:2.12:test (default-test) on project.Error occurred in starting fork -

-
i searched on internet provided answers did not in building project. the error starting fork. tried following methods: mvn clean install -u when searched, people said because of java 7 , should work java 6. using java 6 only. some said set surefire plugin this: <groupid>org.apache.maven.plugins</groupid> <artifactid>maven-surefire-plugin</artifactid> <version>2.5</version> <configuration> <skiptests>false</skiptests> <testfailureignore>true</testfailureignore> <forkmode>once</forkmode> </configuration> the actual error is: [error] failed execute goal org.apache.maven.plugins:maven-surefire-plugin:2.12:test (default-test) on project junitcategorizer.instrument: error occurred in starting fork, check output in log -> [help 1] org.apache.maven.lifecycle.lifecycleexecutionexception: failed execute goal org.apache.maven.plugins:maven-surefire-plugin:2...
Read more

windows - Debug iNetMgr.exe unhandle exception System.Management.Automation.CmdletInvocationException -

-
i fired windows 7 machine today , attempting start intemgr.exe process terminates immediately. started process under debugger. seems process terminating following exception: system.management.automation.cmdletinvocationexception . dumping exceptions on heap yields following results. heap has few more exception listed below. so based on research exception happens when cmdlet encounters terminating error. method call before processrecord(). provides record-by-record processing functionality cmdlet. windows powershell runtime calls method multiple times each instance of cmdlet in pipeline. how can inspect pipeline debugger? exception object: 0000000002702940 exception type: system.management.automation.itemnotfoundexception message: cannot find path 'c:\windows\system32\windowspowershell\v1.0\modules\applicationserver\applicationserver.dll' because not exist. innerexception: <none> stacktrace (generated): sp ip function 000000001...
Read more

unity3d - Fatal error- Monodevelop-Unity failed to start -

-
Image
i installed unity monodevelop seems not been installed tried open script in unity nothing come out, saying should find software opens when have set preferences monodevelop(built-in). then reinstalled again, time, contains visual studio too. can open visual studio. when tried open monodevelop, following pop-up apear. but have installed 2 things /net , gtk. shown below. problem? 1st time-- install gtk after install unity(no monodev) 2nd time-- install monodevelop unity went monodev website , says xamarin studio not monodevelop you messed in first step. you have uninstall gtk , else installed during time. includes unity too.if possible, system restore , set restore date time before installed of this. now, install unity, make sure monodevelop selected unity , install it. don't install gtk or other software. when using unity, monodevelop must installed unity , not other website. reason because using customized version of monodevelop .
Read more