Sql Query with no specific database
-
Hello
When polling MS Sql database with agent, what shoud be written in database name as the query is generic and not specific to single database ?
Database = id=db3;driver=mssql.ddr;server=x.x.x.x;dbname=????;login=xxxx;password=xxxxx Query = query:db3:300:SELECT Count(name) From sys.databases WHERE database_id > 4 AND group_database_id IS not NULL -
Hi,
you can use any database present on that server then, probably "master" could be a good choice as it always exists.
Best regards,
Victor
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login